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!

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
Get step-by-step solutions from verified subject matter experts
