Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the formula needed for the Future Value of Investments in Two Years (E21) Given the following data. Answer should be greater than $17,000,000

What is the formula needed for the Future Value of Investments in Two Years (E21)
Given the following data.
Answer should be greater than $17,000,000 and i cant figure out the formula.
image text in transcribed
Function Library Formula Auditing FV X fx =FVE B D E F Value Last 2 Investments Year Present Value Growth Rate PV Percent to Total 3 Risky A $575,000 $667,000 16.0% 4.1% 4 Risky B $750,000 $840,000 12.0% 5.3% 5 Moderate A $2,500,000 $2,650,000 6.0% 17.6% 6 Moderate B $1,850,000 $1,998,000 8.0% 13.1% 7 Conservative A $3,500,000 $3,622,500 3.5% 24.7% 8 Conservative B $5,000,000 $5,300,000 6.0% 35.3% 9 Total $14, 175,000 $15,077,500 51.5% 10 Average $2,362,500 $2,512,917 11 12 Mortgage Details for Headquarters Annual Interest Repayment Monthly 13 Rate Years Principal Payments 14 4.50% 30 $5,000,000 $25,334 27 15 16 Lease Details for Vehicles Time of Annual Interest Lease in Present Value Future Value 17 Rate Years of Vehicles of Vehicles Monthly Payments 18 2.50% 4 $200,000 $80,000 $5,969.26 19 20 Financial Summary 21 Future Value of Investments in Two Years =FVC 22 Two Year Change in Investments FV (rate, nper, pmt, (pv). [type]) 23 Two Years of Mortgage Payments $608,022.37 24 Two Years of Lease Payments $143,262.31 25 Investment Gains Less Mortgage and Lease Payments #NUM! 26 05

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_2

Step: 3

blur-text-image_3

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

Smart Bitcoin Investor What Are The Advantages Of Bitcoins

Authors: Mohamed Mendieta

1st Edition

979-8353162049

More Books

Students also viewed these Finance questions