Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help . Excel: Complete the amortization table provided in the Excel document posted in Blackboard in the homework area by setting the appropriate values

image text in transcribedPlease help
. Excel: Complete the amortization table provided in the Excel document posted in Blackboard in the homework area by setting the appropriate values for a $130,000, 30-year mortgage at 4.5% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest pald by the end of the mortgage. d. How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)? e. How much interest has been paid total on the mortgage at the end of 10 years? f. How many months will it take to pay at least half of the principal? . Excel: Complete the amortization table provided in the Excel document posted in Blackboard in the homework area by setting the appropriate values for a $130,000, 30-year mortgage at 4.5% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest pald by the end of the mortgage. d. How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)? e. How much interest has been paid total on the mortgage at the end of 10 years? f. How many months will it take to pay at least half of the principal

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions