Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 7

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

Recommended Textbook for

Advanced Accounts

Authors: M.C. Shukla, Sumer Chand Gupta, T.S. Grewal

15th Edition

8121902789, 9788121902786

More Books

Students also viewed these Accounting questions