Question: Use the PV (Present Value) & FV (Future Value) function to determine the outstanding loan balance in Year 5 . Loan Principal $4,000,000 Loan Term

Use the PV (Present Value) & FV (Future Value) function to determine the outstanding loan balance in Year 5.

Loan Principal $4,000,000

Loan Term 15

Interest Rate 10.00%

Payment = 525,895

How do I solve for both PV and FV to find the 5 year amount in excel?

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!

Q:

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Q:

Imagine that you have decided you need a new car, but not any car will do; you have decided to purchase the car of your dreams. Conduct some research as to the cost of this car. You have determined...

Q:

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Q:

I completed the Amortization Schedule and need help with the Future Value formula. 'Use the FV (Future Value) function to determine the outstanding loan balance in Year 5. Use the amortization...

Q:

real estate related. could you solve for FV and PV with the information given? what would the formula/inputs be. Thank you. these would be annual payments. thanks! C D G H Use the FV (Future Value)...

Q:

real estate question B D E F G H Solve for the Overall Value and Overall Cap Rate of the property given the information below. Income Value Land Building Property Rate 9.50% 12.00% $200,000 $62,000...

Q:

complete the problem A B C D NOTE: Both Excel and Manual (calculator) processes are explained below, but we will use just processes (but feel free to try the other...). Please set up below by...

Q:

how come im not getting 3370524 for the PV? my formula is above here is the updated schedule. i am still not getting the exact answer. please advise, thanks. 3 hat Painter - FC Clipboard Font...

Q:

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their 45th payment, and...

Q:

Future Value and Multiple Cash Flows Wellington, Inc. has identified an investment project with the following cash flows. If the discount rate is 5%, what is the future value of these cash flows in...

Q:

You are considering an investment in an apartment complex that has a purchase price of $10,000,000. The potential gross income (PGI) in year 1 is $1,400,000 and is expected to grow 5 percent...

Q:

(3.3) Goods market in an open economy Consider an open economy characterized by the following equations: C=100+0.6(Y-T) I=200+ 0.2Y IM 0.3Y+200 X=0.4Y 600 + 400 I moreover, G= 200, T-200, = 1, Y =...

Q:

Suppose you are depositing an amount today in an account that earns 5 % interest, compounded annually. If your goal is to have $ 7 , 4 7 2 in the account at the end of six years, how much must you...

Q:

Special order pricing Shorewood Shoes Company makes and sells a variety of leather shoes for children. For its current mix of different models and sizes, the average selling price and costs per pair...

Q:

Variable costs and fixed costs Consolidated Minerals (CM) owns the rights to extract minerals from beach sands on Fraser Island. CM has costs in three areas: a. Payment to a mining subcontractor who...

Q:

How does a firms dividend policy affect each of the following? a. The value of its long-term warrants. b. The likelihood that its convertible bonds will be converted. c. The likelihood that its...

Q:

Kelly Company had cash receipts from customers in 2012 of $142,000. Cash payments for operating expenses were $97,000. Kelly has determined that at January 1, accounts receivable was $13,000, and...

Q:

Consider the commodities and financial assets listed in Table 27.6. The risk-free interest rate is 6 percent a year, and the term structure is flat. a. Calculate the six-month futures price for each...

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

4 Which of the following shares are over-valued? The risk-free rate is 5 per cent, and the return on the market index is 10 per cent. Beta Current Rate of Return AB 0.7 7% 1.3 13% C 0.9 9%

Q:

6 The following figures relate to monthly observations of the return on a widely used stock market index (R m ) and the return on a particular ordinary share (R j ) 2over a period of six months. (a)...

Q:

Assume that it is now January 1. The rate of inflation is expected to be 4 percent throughout the year. However, increased government deficits and renewed vigor in the economy are then expected to...