Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Payment Calculator sheet 1. In cell D7, use the function which will calculate the payment the customer will owe each month (display the payment as

image text in transcribedimage text in transcribed

Payment Calculator sheet 1. In cell D7, use the function which will calculate the payment the customer will owe each month (display the payment as a positive value). 2. Complete the two variable data table in cells F5-K20 which shows the payment based upon the number of months by interest rate (Note, you must use the Data Table tool in Excel there will be no duplicated values in the Data Table. If there are then your data table is incorrect. You can highlight cells G6 K20 and press the Delete key to try it again. If it isn't responding, press the Esc key once or twice, then try again). 3. In cell D7, perform Goal Seeking to keep the monthly payment at $3,800 by changing the Sales Price. Accept the goal seeking changes. Copy and paste the new Sales Price in cell B5 to cell B12 (to store for later). 4. Change the Sales Price (B5) back to $987,000. (Note, when you do this, cell B12 should not change to $987,000) J22 fx B C E F G H J K L 1 Hermes Estate Sales 2 12 120 Payment Options Monthly Payments 180 360 Payment Calculator House Payments per year $987,000 Total Payments $90,000 Interest (APR) $897,000 Payment (per month) 30 420 480 360 3.75% 3 4 Property 5 Sales Price 6 Down Payment 7 Loan Amount 8 Period (Years) 9 10 11 Payment Goal: 12 Sales Price 13 14 15 16 17 $3,800.00 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 18 19 20 21 22 23 24 Payment Calculator sheet 1. In cell D7, use the function which will calculate the payment the customer will owe each month (display the payment as a positive value). 2. Complete the two variable data table in cells F5-K20 which shows the payment based upon the number of months by interest rate (Note, you must use the Data Table tool in Excel there will be no duplicated values in the Data Table. If there are then your data table is incorrect. You can highlight cells G6 K20 and press the Delete key to try it again. If it isn't responding, press the Esc key once or twice, then try again). 3. In cell D7, perform Goal Seeking to keep the monthly payment at $3,800 by changing the Sales Price. Accept the goal seeking changes. Copy and paste the new Sales Price in cell B5 to cell B12 (to store for later). 4. Change the Sales Price (B5) back to $987,000. (Note, when you do this, cell B12 should not change to $987,000) J22 fx B C E F G H J K L 1 Hermes Estate Sales 2 12 120 Payment Options Monthly Payments 180 360 Payment Calculator House Payments per year $987,000 Total Payments $90,000 Interest (APR) $897,000 Payment (per month) 30 420 480 360 3.75% 3 4 Property 5 Sales Price 6 Down Payment 7 Loan Amount 8 Period (Years) 9 10 11 Payment Goal: 12 Sales Price 13 14 15 16 17 $3,800.00 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 18 19 20 21 22 23 24

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

Students also viewed these Finance questions

Question

What is a poka-yoke? Give an example.

Answered: 1 week ago