Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(a) If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end

image text in transcribed 

(a) If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: A 1 Required payment (present value) 2 Rate of increase per year if payment is not paid off 3 Account interest rate per year 4 Year of pay off 5 6 7 Required payment 3 years later (using FV function) 8 Required deposit at end of each year (using PMT function) 9 10 11 12 13 14 15 B $90,000.00 4.00% 7.00% C Year Deposit at end of year Accumulated account balance at end of year 1 2 3 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Solution a Project Payment and Deposits 1 Project Payment at Year 3 Cell B7 We need to find the Future Value FV of the initial 90000 considering a 4 a... 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

Personal Finance

Authors: Jeff Madura, Hardeep Singh Gill

4th Canadian edition

134724712, 134724713, 9780134779782 , 978-0134724713

More Books

Students also viewed these Finance questions

Question

Does the person have her/his vita posted?

Answered: 1 week ago

Question

please don't answer the question, the question will be deleted.

Answered: 1 week ago