1) Prepare a Loan Amortization Schedule for the first year Use the Excel template provided, and refer to the formulas of the article Amortization Schedule to calculate Total Monthly Payment, Principal Payment and Interest Payment for each of the months Option II Loan of $150,000, 4 5 , 15 years Loan Amortization Schedule for Year 202X Investment needed 200000 Down payment 25 Loan Amount Annual interest rate 4 5 Monthly interest rate Loan term, in years 15 Loan term, in months Payment date Total monthly payment Principal payment Interest payment Balance January, 202X 0 00 0 00 February, 202X

The Answer is in the image, click to view ...

Question: 1) Prepare a Loan Amortization Schedule for the first year. Use the Excel template provided, and refer to the formulas of the article Amortization Schedule

1) Prepare a Loan Amortization Schedule for the first year. Use the Excel template provided, and refer to the formulas of the article Amortization Schedule to calculate Total Monthly Payment, Principal Payment and Interest Payment for each of the months.

Option II - Loan of $150,000, 4.5%, 15 years
Loan Amortization Schedule for Year 202X
Investment needed	200000
Down payment	25%
Loan Amount
Annual interest rate	4.5%
Monthly interest rate
Loan term, in years	15
Loan term, in months



Payment date	Total monthly payment	Principal payment	Interest payment	Balance
January, 202X	0.00	0.00
February, 202X

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 Accounting Questions!

BM151: Financial Services - Portfolio Project 2 TAX 15 % Portfolio Project Overview For each course of the BFN Program, you will complete two tasks related to creating an online vegetarian catering...

regarding question 3: any kind of loan can be picked and worked. You have found new premises that suit your needs. According to your calculations, buying the premises, creating your own kitchen and...

For your online vegetarian catering business, you rent a commercial kitchen, which requires monthly payments of $1,000. On the one hand, you do not have to think about depreciation, repairs, property...

kim For your online vegetarian catering business, you rent a commercial kitchen, which requires monthly payments of $1,000. On the one hand, you do not have to think about depreciation, repairs,...

Portfolio Project Overview For most of the courses in the Business Fundamentals (BFN) Program, you will complete two tasks related to creating an online vegetarian catering business, which will...

You have found new premises that suit your needs. According to your calculations, buying the premises, creating your own kitchen and organizing a loan requires an investment of $200,000. You have...

Describe the use of situational influence in developing marketing strategy?

A ball of mass 200 g is released from rest at a height of 2.00 m above the floor and it rebounds straight up to a height of 0.900 m. (a) Determine the balls change in momentum due to its contact with...

E5.16 (LO 3) (Retirement of Debt) Rual Fernandez borrowed $90,000 on March 1, 2023. This amount plus accrued interest at 12% compounded semiannually is to be repaid March 1, 2033. To retire this...

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

Explain why each of these statements is not an effective way to convey the negative message: (Objective 4) a. I am sorry I must refuse your request. b. Therefore, following company policy seems to be...

You have been invited to speak at a campaign kick-off reception for Bob Baffle, a candidate for mayor in your city. Bob is a friend of yours, and you plan to support his candidacy. However, the date...

You own Clean Mist Carpets, a company that uses a chemical process for cleaning carpets and removing stains.You do not guarantee success but have a good reputation for stain removal. Mr. and Mrs....