Express Mover is considering adding more space to their existing warehouse with an associated cost of...

  

Transcribed Image Text:

Express Mover is considering adding more space to their existing warehouse with an associated cost of $250,000. Create a new worksheet named, Financing Options to analyze the following scenarios. (All inputs should be explicitly listed and the worksheet should be set up similar to the one that was created during the first part of your Pre Lab.) 1. The monthly payment for the remodel, with a 25% down payment, and an APR of 3.5% compounded monthly. (The loan will be for ten years.) 2. The yearly payment for the remodel, with a 20% down payment, and an APR of 4% compounded quarterly. (The loan will be for ten years.) 3. How many years it would take to pay off the loan, with monthly payments of $3,500 at an APR of 5% compounded monthly, and no down payment. (Round the value to the nearest year) 4. Express Mover has a 10 year CD with an initial value of $35,000 that will be maturing this next month. The initial value of the CD was $35,000, with an APR of 2.25% compounded semi-annually. The company would like to determine if the value of the CD would be enough to make a loan down payment of $50,000. Determine T/F if the maturing CD is enough for the down payment. A B. E G Financing Options $ 250,000 1 2 Estimated Remodel Cost: Amount Future Compounding Payment Value Options Down payment:25%, APR 3.5% 4 Duration: 10 Years, Compounded Monthly Financed APR Years Periods $ 187,500 3.50% ($1,854.11) 10 12 Down payment:20%, APR 4% 5 Duration: 10 Years CD, Compounded Quarterly $ 200,000 ($6,091.12) 10 4% Down payment:0, APR 5% 6 Monthly Payment:$3,500, Compounded Monthly 7 Is the CD worth enough for a down payment of $50,000?(T/F) $ 250,000 5% 12 3. Express Mover is considering adding more space to their existing warehouse with an associated cost of $250,000. Create a new worksheet named, Financing Options to analyze the following scenarios. (All inputs should be explicitly listed and the worksheet should be set up similar to the one that was created during the first part of your Pre Lab.) 1. The monthly payment for the remodel, with a 25% down payment, and an APR of 3.5% compounded monthly. (The loan will be for ten years.) 2. The yearly payment for the remodel, with a 20% down payment, and an APR of 4% compounded quarterly. (The loan will be for ten years.) 3. How many years it would take to pay off the loan, with monthly payments of $3,500 at an APR of 5% compounded monthly, and no down payment. (Round the value to the nearest year) 4. Express Mover has a 10 year CD with an initial value of $35,000 that will be maturing this next month. The initial value of the CD was $35,000, with an APR of 2.25% compounded semi-annually. The company would like to determine if the value of the CD would be enough to make a loan down payment of $50,000. Determine T/F if the maturing CD is enough for the down payment. A B. E G Financing Options $ 250,000 1 2 Estimated Remodel Cost: Amount Future Compounding Payment Value Options Down payment:25%, APR 3.5% 4 Duration: 10 Years, Compounded Monthly Financed APR Years Periods $ 187,500 3.50% ($1,854.11) 10 12 Down payment:20%, APR 4% 5 Duration: 10 Years CD, Compounded Quarterly $ 200,000 ($6,091.12) 10 4% Down payment:0, APR 5% 6 Monthly Payment:$3,500, Compounded Monthly 7 Is the CD worth enough for a down payment of $50,000?(T/F) $ 250,000 5% 12 3.

Answer rating: 100% (QA)

Solution A B D F G Financing Options 250000 1 2 Estimated Remodel Cost Future Compounding Options Am... View the full answer