Question: How do you use the financial formulas to get the answers in this excel worksheet? Thanks! 1 ILLUSTRATION 9-2: The Maximum Amount You Should Borrow

How do you use the financial formulas to get the answers in this excel worksheet? Thanks!

How do you use the financial formulas to get the answers in

1 ILLUSTRATION 9-2: The Maximum Amount You Should Borrow 3 1/Y = 7.5 7.50% Fill in all green cells 5 N = 20 20 7 PMT = 10,000 10000 CPT PV = Principal = 12 ILLUSTRATION 9-3: The interest rate to negotiate 14 1/Y = 7.5 7.50% 16 N = 20 20 10000 PMT = 10,000 PV = -110000 Max interest rate? = 21 Principal Needed = -110000 Max Amortization rate?= ILLUSTRATION 9-4: Finding the optial amortization rate 0.075 250000 28 Payments if the interest rate is principal amortization What is my payment? = 30 29 1 ILLUSTRATION 9-2: The Maximum Amount You Should Borrow 3 1/Y = 7.5 7.50% Fill in all green cells 5 N = 20 20 7 PMT = 10,000 10000 CPT PV = Principal = 12 ILLUSTRATION 9-3: The interest rate to negotiate 14 1/Y = 7.5 7.50% 16 N = 20 20 10000 PMT = 10,000 PV = -110000 Max interest rate? = 21 Principal Needed = -110000 Max Amortization rate?= ILLUSTRATION 9-4: Finding the optial amortization rate 0.075 250000 28 Payments if the interest rate is principal amortization What is my payment? = 30 29

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!