Answered step by step
Verified Expert Solution
Question
1 Approved Answer
in excel i need help creating a formula to calculate the initial loan amount. i am pretty sure i need to use the function PV
in excel i need help creating a formula to calculate the initial loan amount. i am pretty sure i need to use the function PV but not getting the right answer
i need to fill in b7. it should =$2,000,000
song + STO Select Draw with Eraser Lasso Touch Select Add Pen Ink to Ink to Shape Math Ink Replay Replay Tools Pens Convert ADDRESS fi =PVC A B C D E Manitou Mountain Resort 1 3.625% 15 2 Mortgage Loan Payment Calculator B Date 10-Mar-2020 Rate 4 Item Slopestyle Inn Term (Years) 5 Price $ 2,255,000.00 Quarterly Payment 6 Down-Payment $ 473,500.00 Total Interest 17 Amount Borrowed =PVC Total Cost 8 Varying Interest Rate Schedule 10 Rate Quarterly Payment Total Interest 11 $ 312,744,110.59 $ 473,500.00 9 Total Cost 12 13 3.00% 3.13% 14 15 6 7 song + STO Select Draw with Eraser Lasso Touch Select Add Pen Ink to Ink to Shape Math Ink Replay Replay Tools Pens Convert ADDRESS fi =PVC A B C D E Manitou Mountain Resort 1 3.625% 15 2 Mortgage Loan Payment Calculator B Date 10-Mar-2020 Rate 4 Item Slopestyle Inn Term (Years) 5 Price $ 2,255,000.00 Quarterly Payment 6 Down-Payment $ 473,500.00 Total Interest 17 Amount Borrowed =PVC Total Cost 8 Varying Interest Rate Schedule 10 Rate Quarterly Payment Total Interest 11 $ 312,744,110.59 $ 473,500.00 9 Total Cost 12 13 3.00% 3.13% 14 15 6 7Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started