Question: Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario: 2 years ago Janice got a $100,000, 15-year mortgage

Spreadsheet 1: Amortization Table

Create an amortization table in MS-Excel in the format shown below:

Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the

Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6% and monthly payments.

1) What is her monthly payment?

2) How much does she owe today (after 24 payments)?

3) How much will she owe in 3 years (after 60 payments)?

4) How much will she owe in 3 years (after 60 payments) if she makes an extra $200 payment every month starting today?

LOAN ANALYSIS: Prepared by Kent Saunders Principal $10,000.00 Annual interest 10.00% 10 Term (years) Payment periods per year No. of payments Periodic rate of interest 5.00% Basic P ayment per period$802.43 Added payment Pmt Beg. Principal Added AppliedEnding Cumulativie Balance Interest Payment Payment Principa Balance Interest 500.00 9,697.57 484.88802.430.00 317.559,380.02984.8S 9,380.02469.00 802.43 0.00 333.43 9,046.591,453.88 9.04659 52.33 802.43 0.00 350.10 8.696.49 906.21 10,000.00 500.00802.430.00 302.43 9,697.57

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!

Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6%...

Thank you for your time in helping me with this problem. I am very confused and need assistance. Scenario: 10 years ago, Janice got a $250,000, 30-year mortgage with an annual interest rate of 6% and...

Data link: https://drive.google.com/drive/folders/1txHtl8_W2u1rUnGwdgDONyfg22KVKWUP?usp=sharing CAS 171 - Final Project: Computer Warehouse Data Files: ComputerWarehouse.accdb,...

i increase the price but i need that you check the general journal because it's automatically the worksheet you can't change the worksheet Building Blocks of Accounting .. A Financial Perspective to...

Hello I need help with my Project i asked and I tried but i did get any answer can you help me please to solve this problem Building Blocks of Accounting .. A Financial Perspective to the same screen...

I have attached a file with real estate mortgage problems. Real Estate and Society Spring 2017 1. You have borrowed $550,000 for Bank of America. The loan is a traditional fixed mortgage loan at...

Wheeler's Bike Company manufactures custom racing bicycles. The company uses a job order cost system to determine the cost of each bike. Estimated costs and expenses for the coming year follow: Bike...

The CR-V campaign in Iceland has been receiving effectiveness awards for years. Why do you think that is so? What are the strengths of its marketing communication approach? What might you suggest to...

In three months time Razzo Inc. will receive EUR 5 , 0 0 0 , 0 0 0 from another customer. Six months ago the firm sold EUR 5 , 0 0 0 , 0 0 0 against the GBP using a nine - month forward contract at...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...