Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

complete the schedule Excel Online Activity: Amortization schedule muestion 1 10 Video Excel Online Structured Activity: Amortization schedule The data on a loan has been

complete the schedule image text in transcribed
image text in transcribed
image text in transcribed
Excel Online Activity: Amortization schedule muestion 1 10 Video Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $37.000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate in 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Balance Payment Interest of Prinoval Balance Year 1 $ $ $ $ $ 2 $ $ $ 5 $ 3 $ $ b. What percentage of the payment represents interest and what percentage represents prinopal for each of the three years? Round le Horse X. Excel template Saved Re Data Review View Help Tell me what you want to do 10 A A Home Insert Formulas Xon Anal Da Copy Paste Format Painter Clipboard Cuency $. % 13 -A- Insert Delete Format Conditional Format Cell Formatting Table Styles bles Font Alignment Numbe C Undo B8 0 E F G H 1 Amortization schedule 2 3 Loan amount to be repaid (PV) Interest rate (0) 5 Length of loan in your $37,000.00 8.00% 3 NO Formula a Setting up amortization table Calculation of loan payment Repayment of Principal 10 Beginning Balance Payment Interest Remaining Balance Yeni 1 2 3 13 15 b. Calculating % of Payment Representing Interest and Principal for Each Your Payment Payment Representing Representing Check out Yea Principal 100% & Shooti Car Mode Automatic WorkbookStatis + Undo > Clipboard Font Alignment Number Tables Cells B9 D E F G H Representing Interest Representing Principal Check Total 100% - TE 17 18 19 20 21 Formulas Year 1 2 3 Repayment of Primcipal NA WWA MUA Remaining Balance NA NA WNIA 22 Year Beginning Balance Payment Interest 23 1 WNA WNIA NA 24 2 WINIA MNIA WNA 3 DNA WNIA NA 26 27 b. Calculating % of Payment Representing Interest and Principal for Each You Payment Payment Representing Representing Check Total Year Interest Principal 100% 1 WNIA WIWA MIVA 2 NA NA WNIA 3 UNIA NA WNA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 10th Edition

1337902578, 978-1337902571

More Books

Students also viewed these Finance questions

Question

Did you include a prominent, attention-grabbing headline?

Answered: 1 week ago

Question

Did you follow BANGPP design checklist to review the layout?

Answered: 1 week ago