Problem (a) What is the future value of the following unequal cash flows using 9 interest rate year 1 2 3 4 cash flow 600 800 500 400 (b) What is the present value of the above unequal cash flows using 7 5 interest rate PLEASE ANSWER THIS BY EXCEL THANKS

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 06, 2024

Problem (a) What is the future value of the following unequal cash flows using 9% interest rate? year 1 2 3 4 cash flow 600

Problem

(a) What is the future value of the following unequal cash flows using 9% interest rate?

year	1	2	3	4
cash flow	600	800	500	400

(b) What is the present value of the above unequal cash flows using 7.5% interest rate?

PLEASE ANSWER THIS BY EXCEL.

THANKS!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 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

The Forex Trading Manual The Rules Based Approach To Making Money Trading Currencies

Authors: Javier H. Paz

1st Edition

0071782923,0071782931

More Books

Students also viewed these Finance questions

Question

★★★★★

In determining the amount of a realized gain or loss to be recognized in the current year, certain types of gains and losses are deferred, whereas others are disallowed. What is the difference...

Answered: 1 week ago

Question

★★★★★

5. Use a systematic, logically connected sequencing of learning activities so that trainees have mastered lower levels of learning before moving onto higher levels.

Answered: 1 week ago

Question

★★★★★

Texaco. Did Texaco do anything unethical by claiming that the people on tape were bad apples?

Answered: 1 week ago

Question

★★★★★

(Entries for Bond TransactionsStraight-Line) Foreman Company issued $800,000 of 10%, 20-year bonds on January 1, 2011, at 102. Interest is payable semiannually on July 1 and January 1. Foreman...

Answered: 1 week ago

Question

★★★★★

Find the missing numbers. % Markup on Selling Cost Price Markup Cost Price ? ? 3296 $2408 Cost price = $5.84 Markup = $18.24 Cost price = $18.24 Markup = $5.84 Cost price = $16.37 Markup = $7.71 Cost...

Answered: 1 week ago

Question

★★★★★

Question 2 Current Attempt in Progress A list of francial statement items for Blossom Company includes the following accounts receivable $29.00, prepaid insurance 15.460 cash $21.840, supplies...

Answered: 1 week ago

Question

★★★★★

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago

Question

★★★★★

You expect to receive $120 in one year and $270 in two years. What is the present value of the money today assuming an interest rate of 3.50% in year one and 4.25% in year 2?

Answered: 1 week ago

Question

★★★★★

What is the best conclusion for Xbar Chart? UCL A X B C B A LCL

Answered: 1 week ago

Question

★★★★★

A baseball catcher is performing a stunt for a television commercial. He will catch a baseball with mass m = 173 g, dropped from rest at a height y = 62 m above his glove. The glove brings the ball...

Answered: 1 week ago

Question

★★★★★

The following information comes from the records of Magno Co. for the current period: Actual costs and quantities: Direct materials used Direct labor hours used 38,000 feet @ $6.20 per foot 50,660...

Answered: 1 week ago

Previous Question Next Question