Kerry Johnson is applying for a loan so that he can purchase a new machine from overseas for his printing business. Due to theUsing the accompanying Retirement$\_$Calculator spreadsheet model, Claire wants to use Scenario Manager to compare the followingUsing the accompanying Retirement$\_$Calculator spreadsheet model, Claire wants to use Scenario Manager to compare the following

retirement saving scenarios:

Click here for the Excel Data File

a$.$ Which scenario generates the highest retirement savings at the end of $10$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

b$.$ Which scenario generates the lowest retirement savings at the end of $20$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

c$.$ Which scenario generates the second highest retirement savings at the end of $30$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

Scenario generates $2$nd highest retirement savings

Amount

d$.$ For Scenario $4,$ if Claire would like to have $$1$ million at the end of $30$ years, what would her saving rate need to be$?$ How about at

the end of $20$ years?

Note: Round your answers to $2$ decimal places.

retirement saving scenarios:

Click here for the Excel Data File

a$.$ Which scenario generates the highest retirement savings at the end of $10$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

Scenario generates the highest retirement savings

Amount

b$.$ Which scenario generates the lowest retirement savings at the end of $20$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

Scenario generates the lowest retirement savings

Amount

uncertainties in importing tariff, Kerry estimates that the machine may cost either $$150,000$ or $$185,000$ when he places the order. The

loan interest rate can also fluctuate between $5\%$ and $7\%.$ Kerry plans to pay off the loan in $10$ years. Use the accompanying Loans

spreadsheet model to answer the following questions.

Click here for the Excel Data File

a$.$ Help Kerry plan the best$-$ and worst$-$case scenarios for his loan using Scenario Manager. What are the monthly payment amounts for

the best$-$ and worst$-$case scenarios?

Note: Round your answers to $2$ decimal places.

Best$-$case monthly payment

Worst$-$case monthly payment

b$.$ Kerry estimates that his monthly revenue increase due to the new machine will be $$2,500.$ What is the loan amount that Kerry can

afford if he wants to break even, assuming a $10-$year loan with $6\%$ interest?

Note: Round your answer to $2$ decimal places.

Loan amount

c$-1.$ Kerry is able to find a domestic manufacturer that makes the same equipment. The cost of the machine is $$220,000$ if Kerry

purchases it from the domestic manufacturer, but the company offers Kerry a favorable $4\%$ loan for a $10-$year term. Compare Kerry's

monthly payment if he purchases from the domestic manufacturer to the scenarios he created earlier.

Note: Round your answer to $2$ decimal places.