Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sports Plus is a sporting goods retail store. They want to use Excel to help them decide the best way to fund a major building

Sports Plus is a sporting goods retail store. They want to use Excel to help them decide the best way to
fund a major building expansion. They have found two banks that will lend them the money for the expansion. The terms from each bank are listed in the start file.
1. Calculate the monthly payment amount and the total amount of interest paid for each option in the green cells. Calculations must contain cell references to the inputs and assumptions so that if input
values change, the calculations and output values will change as well. Round all values to the nearest dollar.
Notes: For the terms offered by Bank 1, you must consider that the 0% Down Payment is an input and may change, so it should be included in the subsequent calculations of the monthly payment and total interest paid. Also be sure that the starting input for the Bank 1 Annual Interest Rate is 3.5% and the Bank 2 Annual Interest Rate is 4.0%
2. For the terms offered by Bank 1 complete the one-variable data table to show the impact of changes in the Down Payment on the Monthly Payment.
3. For the terms offered by Bank 2 complete the two-variable data table to show the sensitivity of the total interest paid amount to changes in interest rates and changes in loan terms. Format the results of the two-variable data table to currency and round to the nearest dollar.
4. Assume Sports Plus can negotiate the interest rate from Bank 2. What interest rate should they request to make the total interest paid in the loan from Bank 2 equal to the total interest paid in the loan
from Bank 1? Use Goal Seek. (You do not need to leave the result of Goal Seek in the input cell, but make a note of the answer is it is needed when you complete the myCourses questions.)
image text in transcribed

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

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

Recommended Textbook for

Monetary Policy Strategy

Authors: Frederic S. Mishkin

1st Edition

0262513374, 978-0262513371

More Books

Students also viewed these Finance questions

Question

Why are malicious insiders a focus of security experts?

Answered: 1 week ago