Homeworkassignment3_Question17

xlsx

School

Wayne State University *

*We aren’t endorsed by this school

Course

FINANCIAL

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

2

Uploaded by nicol3k3lly

Report
Function: FV, SUM; Cell referencing Some cells are merged. Problem 6.19 - Future Value with Multiple Cash Flows PROBLEM Year 1 Investment $ 331,000 Year 2 Investment $ 616,450 Year 3 Investment $ 212,775 Year 4 Investment $ 818,400 Year 5 Investment $ 1,239,644 Year 6 Investment $ 1,617,848 Interest Rate 6.75% The t Requi Trigen Corp. management will invest $331,000, $616,450, $212,775, $818,400, $1,239,644, and $1,617,848 in research and development over the next six years. The interest rate is 6.75%. Use th from t to det appro blank
Student Work Area Investment Cash Flow FVF Future Value Year 1 Investment 331,000 1 $ 458,846.49 Year 2 Investment 616,450 1 $ 800,514.85 Year 3 Investment 212,775 1 $ 258,835.74 Year 4 Investment 818,400 1 $ 932,612.84 Year 5 Investment 1,239,644 1 $ 1,323,319.97 Year 6 Investment 1,617,848 1 $ 1,617,848.00 total future value of these investments is: $ 5,391,977.89 ired: Provide input into cells shaded in gray in this template. he FV function in excel to determine the future value of each investment eight years today by referencing the appropriate cells in the Problem area. Use the SUM function termine the future value of all the investments combined by referencing the opriate cells in the Student Work Area. Do not leave any portion of the FV function - insert 0's if you have not been given the requested information.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help