Question: Loan Schedule Loan Amount: $ 7 0 0 , 0 0 0 Annual Interest Rate: 8 % Term ( Years ) : 9 Origination Date:

Loan Schedule
Loan Amount: $700,000
Annual Interest Rate: 8%
Term (Years): 9
Origination Date: 1/1/21
Monthly payment: $9,113
Annual payment: $109,357
Payment Schedule
Payments "2021
(Months 1-12)""2022
(Months 13-24)"
Interest portion
Principal portion
Total payment -
12/31/2112/31/22
Principal balance

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

PROBLEM 1 Fisher Lending Corporation approved a loan in the amount of P5,000,000 on January 1, 2018. The interest rate on the loan is 10% payable annually starting December 31, 2018. The loan matures...

Q:

QUESTION 3 [14 marks] Bill has bought a new home in Canberra. He borrowed $600 000 at a 12 rate given as 150 basis points over the Australian 10-year government bond yield for 2018. The loan is to be...

Q:

1. Enter cell references and formulas where indicated in the Amortization Schedule. 2. Drag Row 14 down to complete rows 15-23. 43. Verify your principal balance is $0 and the end of year 10. Journal...

Q:

7) (14 points) Future Value/Present value: A student takes an education loan from a bank. He expects to borrow $40,000 a year for the next 4 years (the first amount is drawn immediately, on...

Q:

I only need the answers to the last workbook, the income statement page. I wrote page 1 & 2 on them. Please show the answers on excel like the one I have below. Thanks! A G H B C E F Before you...

Q:

The next four questions use data from the LBO-Item-Set-3.xlsx" file, which can be downloaded by clicking here. You do not need data from Sections 3 and 4 to answer this question. You are modeling a...

Q:

need help with APR excel 2. Origination Fees and Discount Points with Prepayment at EOY 6 A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800...

Q:

green part needs answered AutoSave OFF A Module Ma Home Insert Draw Page Layout Formulas Data Review View Tell me fx v v Define Name 2 A AutoSum Recently Financial Logical Text Used Insert Function...

Q:

ASSIGNMENT 2-MORTGAGE AMORTIZATION TABLE This assignment is to use your knowledge of Chap 1-5 to generate the following amortization table in a file given user's input of loan amount, annual interest...

Q:

1) 2) 3) A mortgage loan in the amount of $100,000 is made at 6 percent interest for 20 years. Payments are to be monthly in each part of t problem. Required: a. What will monthly payments be if (1)...

Q:

Tescacs assets are worth $300. It has $180 of zero-coupon debt outstanding that is due to be repaid at the end of three years. The risk-free interest rate is 5%, and the standard deviation of the...

Q:

The comb function is defined by IIIT(t) = > d(t - kT). k=-0 (a) (10 Pts) Represent IIIT(t) as a Fourier series. That is, determine a sequence {ak} such that IIIT(t) = akej2akt/T. k=x (b) (10 Pts)...

Q:

Which of the following taxes is reduced when an employee contributes towards their 4 0 1 k plan? A . Federal income taxes B . Social Security taxes C . Medicare taxes D . Unemployment taxes

Q:

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.