Question: how would I calculate those problems in excel ? Times 19 TVM Excel Homework_BUS230B_S2020.docx Locked Regular 12 VOYB I U EEID 1.0 0 EV T2

how would I calculate those problems in excel ? how would I calculate those problems in excel ? Times 19 TVM

Times 19 TVM Excel Homework_BUS230B_S2020.docx Locked Regular 12 VOYB I U EEID 1.0 0 EV T2 1 HOMEWORK ASSIGNMENT You have $150,000 to invest. You need the money in 15 years and you expect to earn 8% per year. How much will you have in 15 years? Steve needs $250,000 in 8 years for his daughter's education. If he can earn 6% per year, how much does he need to invest today? You have $13,000 to invest and you need $50,000 for a down payment and closing costs on a house. If you want to buy the house in 6 years, what rate of interest do you need to earn? You have $3,000 to invest right now and you figure you will need $25,000 to buy a new car. If you can earn 6% per year, how long before you can buy the car? Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is 6 percent compounded annually? Year Casii Flow 6,000 4,000 9,000 2,000 2

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!