Question: Use a spreadsheet to create amortization schedules for the following five scenarios. What happens to the total interest paid under each scenario? a. Scenario 1:

Use a spreadsheet to create amortization schedules for the following five scenarios. What happens to the total interest paid under each scenario?

a. Scenario 1:

Loan amount: $1 million

Annual rate: 5 percent

Term: 360 months

Prepayment: $0

b. Scenario 2: Same as 1, except annual rate is 7 %

c. Scenario 3: Same as 1, except term is 180 months

d. Scenario 4: Same as 1, except prepayment is $250 per month

e. Scenario 5: Same as 1, except loan amount is $125,000

Step by Step Solution

★★★★★

3.43 Rating (181 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Beginning Ending Period Balance Payment Interest Principal Balance 1 100000000 536822 416667 120155 99879845 2 99879845 536822 416166 120656 9975918... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

428-B-A-T-V-M (1714).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Use a spreadsheet to calculate the 2-day and 5-day SMA for ten consecutive day closing prices of Yahoo! Inc. Graph the closing prices and averages. 21-Apr 28.55 1-May 26.81 22-Apr 28.54 2-May 28.67...

Use a spreadsheet to generate the last year of payments in a loan amortization table for a $600,000, 15-year mortgage with an APR of 5.5%?

2. [-/3.12 Points] ASK YOUR TEACHER PRACTICE ANOTHER (An Intermediate Algebra review exercise) Use polynomial long division to perform the indicated division. Write the polynomial in the form...

QUESTION 2 [20 Marks] The Pines Cottage is a luxury holiday cottage set in the heart of pretty Burford in Oxfordshire. It was established by Harry and Megan over ten years ago. This property has...

Scenario 1-Vanilla You are a loan officer and your next client is Sandra Patterson. Sandra wants to borrow $200,000 from the bank at 6 percent interest compounded monthly to be repaid over thirty...

The interest rate I chose >> 2.198 (Chegg doesn't support links so please feel free to find any home in the metropolitan Detroit area with a price over $19,999!) Thanks for the help! Find a current...

Real Estate: The BUY vs. RENT Decision On a crisp morning in February 2022, Julianne Chant was sitting in her chair and enjoying the quiet in her office before a busy day. Turning her chair toward...

Hello , Can you help me with this week assignment . Same as last ones . Office 2013 - myitlab:grader - Instructions Exploring Excel Ch. 06 - A1 Project What-If Analysis Project Description: You are...

answer question 5 a, b, c and 6 a, b, c please Instructions-Np-EX16-9: Word es Mailings Review View Help Tell me what you want to do 5. Switch to the Amortization worksheet. Calculate the curnulative...

Simple Loan Calculator Loan amount Annual interest rate Loan period in years Start date of loan Enter values $ 5,000.00 6.50% 3 1/1/21 $ Monthly payment Number of payments Total interest Total cost...

(a) Find all roots of f(x) = x2 + 4x if f(x) Z12[x]. (b) Find four distinct linear polynomials g(x), h(x), s(x), t(x) Z12[x] so that f(x) = g(x) h(x) = s(x)t(x). (c) Do the results in part (b)...

One of the most important aspects of information assurance is ensuring that proper policies and procedures are established within an organization. Without proper policies and procedures, there would...

The Supreme Court has stated that abandoning an item takes it out of the protection of the Fourth Amendment. Have you abandoned your items if you leave them on a table in a public library while you...

Prior to expiration, the lowest value of a European put option is the greater of zero or the: A. exercise price minus the value of the underlying. B. present value of the exercise price minus the...

What is the form of business organization taken by most large companies and why?

What is the primary responsibility of the board of directors in a corporation?

All public companies must hire a certified public accounting firm to perform an independent audit of their financial statements. What exactly does the term audit mean?

$80,000 is due 20 years from today. The borrower wants to make quarterly payments into a fund that will earn compound interest at an annual rate of 5%, compounding monthly. What will the quarterly...

Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.1 Days sales outstanding: 73.0 days a Inventory turnover ratio: 4 Fixed assets turnover:...

explained both parts please My Courses Question 2 Not yet answered Points out of 50.00 P Flag question Due to a sudden downturn in the California economy, the State of California decides it needs to...