Question: Create an amortization table in MS-Excel in the format shown below: LOAN ANALYSIS: Prepared by Kent Saunders Principal $10,000.00 Annual interest | 10.00% Term (years)

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

Create an amortization table in MS-Excel in the format shown below: LOAN ANALYSIS: Prepared by Kent Saunders Principal $10,000.00 Annual interest | 10.00% Term (years) 10 Payment periods per year No. of payments 20 Periodic rate of interest 5.00% Basic Payment per period $802.43 Added payment Pmt No. Beg. Principal Balance 10,000.00 9.697 57 9,380.02 9,046.59 Interest 500.00 484.88 469.00 452.33 Added Applied Payment Payment Principal 802.43 0.00 302.43 802.43 0.00 317.55 802.43 0.00 333.43 802.43 0.00 350.10 Ending Cumulative Balance Interest 9 ,697.57 500.00 9.380.02 9 84.88 9,046.59 1,453.88 8,696.49 1,906.21 3 Scenario: 2 years ago Janice got a $150,000, 30-year mortgage with an annual interest rate of 8% 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 with her next payment

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!

Create an amortization table in MS-Excel in the format shown below: LOAN ANALYSIS: Prepared by Kent Saunders Principal $10,000.00 Annual interest 10.00% Term (years)! 10 Payment periods per year 2...

Create an amortization table in MS-Excel in the format shown below: 10 LOAN ANALYSIS: Prepared by Kent Saunders Principal $10,000.00 Annual interest | 10.00% Term (years) Payment periods per year No....

JUST ANSWER THE FIRST PAGE: ALL INFO ARE ALREADY GIVEN PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by making yearly payments of P50,...

TO BE ANSWERED: All of theinfos are already given below just answer the first photo PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

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

The screenshots below are all about FS preparations. There are supporting attachments from A-O. YESUCAN COMPANY Financial Information (Monetary values are in Philippine Peso) YESUCAN COMPANY (the...

Figure 3. GPA study data. You can download the GPAs spreadsheet and use it for the exercises. Step 1: Analyzing the Grades Sue thinks that students are more motivated to do well in their major...

Chapter 6 Evaluating the Steps To Success: Level 2 developed in Europe to mold skis more precisely and less expensively than the The Equipment division at The Zone is looking into a new piece of...

What are leasehold improvements? How should a company account for them?

On April 1, Julie Spengel established Spengels Travel Agency. The following transactions were completed during the month. 1. Invested $15,000 cash to start the agency. 2. Paid $600 cash for April...

Research suggests that many expatriate employees encounter problems that limit both their effectiveness in a foreign posting and their contribution to the company when they return home. What are the...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

4. In small groups in your class, discuss how popular culture and films portray interpersonal relationships, considering specifically relationship stages. Discuss communication techniques that the...

1. List one family relationship, one friendship, and one romantic relationship in which you are or have been involved. For each of these relationships, list at least five self-disclosures you made to...

B In light of the information you have gleaned from this chapter, how would you prepare to have a conversation about repairing the relationship no matter which decision you make? What repair tactics...