Question: Task: Complete the loan amortization schedule in the green cells below. You must use at least one of the following formulas (PMT, IPMT, PPMT) in

Task: Complete the loan amortization schedule in the green cells below.

You must use at least one of the following formulas (PMT, IPMT,

PPMT) in your solution. Where did I go wrong? Complete the loan

amortization schedule in the green cells below. You must use at least

Task: Complete the loan amortization schedule in the green cells below. You must use at least one of the following formulas (PMT, IPMT, PPMT) in your solution. Where did I go wrong?

Complete the loan amortization schedule in the green cells below. You must use at least one of the following formulas (PMT, IPMT, PPMT) in your solution. Years Periods per year 30 12 Interest Principal Paid Annual Interest Rate Lump Sum Period PMT 8 =ROWS(A$8:A8 9 =ROWS(A$8:19 =ABS(PMT($F9/$F$5,$A$368,$E$8)) 10 =ROWS(A$8:41=ABS(PMT($F10/$F$5,$A$368,$E$8)) 11 =ROWS(A$8:41 =ABS(PMT($F11/$F$5,$A$368,$E$8))+G11 12 =ROWS(A$8:A1 =ABS(PMT($F12/$F$5,$A$368,$E$8))+G12 Balance 350000 =E8-D9 =E9-D10 =E10-D11 =E11-D12 =ABS(IPMT($F9/$F$5,49,$A$368,$E$8)) =ABS(PPMT($F9/$F$5,49,$A$368,$E$8)) =ABS(IPMT($F10/$F$5,410,$A$368,$E$8)) |=ABS(PPMT($F10/$F$5, A10,$A$368,$E$8)) =ABS(IPMT($F11/$F$5,411,$A$368,$E$8)) =ABS(PPMT($F11/$F$5,411,$A$368,$E$8)) =ABS(IPMT($F12/$F$5,412,$A$368,$E$8)) =ABS(PPMT($F12/$F$5,412,$A$368,$E$8)) 0.08 0.08 0.08 10000 0.08 Period PMT Interest Principal Paid Annual Interest Rate Lump Sum 2,568.18 2,568.18 12,568.18 2,568.18 2,333.33 2,331.77 2,330.19 2,328.61 234.84 236.41 237.98 239.57 Balance 350,000.00 349,765.16 349,528.75 349,290.76 349,051.19 0.08 0.08 0.08 0.08 10,000.00 10000 80 =ROWS(A$8:A8 =ABS(PMT($F80/$F$5,$A$368,$E$8))+G80 =ABS(IPMT($F80/$F$5, A80,$A$368,$E$8)) =ABS(PPMT($F80/$F$5, A80,$A$368,$E$8)) 81 =ROWS(A$8:A8 =ABS(PMT($F81/$F$5,$A$368,$E$8))+G81 =ABS(IPMT($F81/$F$5, A81,$A$368,$E$8)) =ABS(PPMT($F81/$F$5, A81,$A$368,$E$8)) 82 =ROWS(A$8:48. =ABS(PMT($F82/$F$5,$A$368,$E$8))+G82 =ABS(IPMT($F82/$F$5, A82,$A$368,$E$8)) =ABS(PPMT($F82/$F$5, A82,$A$368,$E$8)) 83 -DOWSIASA-AI-ARSIMTISF83/$E$5 $A$368 SEVG83 - ARSTIDMTISF83/$E$5 83 $A$368 SE -ARSIDDMTISF83/$E$5 83 $A$368 SEY =E79-D80 =E80-081 =E81-D82 -F82.083 0.075 0.075 0.075 In 075 365 35| 366358|| 367359 368 360 2.447.25| 2,447.25|| 2,447.25| 2,447.25|| 60.24|| 45.32|| 30.31 15.20 12.387.01] 10.027.93] 2.401.93 7,625.99 2.416.94] 5.209.05 2,432.05| 2.77.00 0.075 0.075 0.075 10.075

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!

Grant Corp invested $1.8M on 4/1/2019. At the time, the project manager assigned forecasted that the cost of capital was 17% and the profit change for year ended '19 - '23 were as follows: 300K,...

EXCEL: Complete the loan amortization schedule in the green cells below. You must use at least one of the following formulas (PMT, IPMT, PPMT) in your solution. Years Periods per year 30 12 Period...

The attached file contains explanations on how to complete the excel assignment. You MUST follow all rules and formulas to get the solutions...etc/ Please send me the completed excel sheet that...

The Coach Caf is a small neighborhood caf that serves vegetarian breakfasts and lunches. The owner of the caf, Keith Watson, started the caf with $50,000 of his own money. Now that hes up and...

Project Description: You work for a dothing distributor that has locations in lowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main ernployee data set, use...

Loan Analysis (the question is the first part, then the data is the tables) Files Needed: File 09-Coach Cafe Business Plan.xlsx The Coach Caf is a small neighborhood caf that serves vegetarian...

The Coach Caf is a small neighborhood caf that serves vegetarian breakfasts and lunches. The owner of the caf , Keith Watson, started the caf with $ 5 0 , 0 0 0 of his own money. Now that he s up and...

The Coach Caf is a small neighborhood caf that serves vegetarian breakfasts and lunches. The owner of the caf, Keith Watson, started the caf with $50,000 of his own money. Now that hes up and...

For this case assume: You have located a home that you wish to purchase and wish to evaluate bank financing options in order to determine your budget. Youve been working with a few banks on potential...

13. Use a currency format (with 2 decimal places) in all cells in columns B, C, D, E of your schedule, showing dollars and cents e.g. $12,345.67. 14. Apply all borders to all cells in the loan...

Acme is an accrual basis corporation. Mrs. T, Acmes chief financial officer, is a cash basis individual. In December 2015, Acmes board of directors decided that Mrs. T should receive a $20,000 bonus...

Fairchild, Inc., manufactures two products, Regular and Deluxe, and applies overhead on the basis of direct labor hours. Anticipated overhead and direct labor time for the upcoming accounting period...

Samson Enterprises increases its annual dividend by 3 . 2 % each year. The common stock has a market price of $ 3 6 . 4 9 a share on a required retum of 9 . 7 % . What is the amount of its next...

Calculate the minimum and maximum takt time for the given

2 Do you ever listen to music while you study? How carefully are you really listening to it? Is it just background noise that you actually tune out?

B If you are able to hear, does it strike you as surprising that in Deaf culture, you might be labeled as deficient in the realm of nonverbal communication? How might this influence how you view your...

4 What kind of meaning might be lost if a poem born in ASL were to be translated into written form? Can a nonsigner truly appreciate the performance of a signed poem?