Create a user defined function to calculate the future value of an uneven stream of cash flows assuming an interest rate of 7 Test your formula using the following cash flows Time 1 2 3 4 5 Cash Flow $200 $300 $100 $400 $500 Use the ForNext loop in your function, and call the function FVCFA Still using a ForNext loop, rewrite your function so that it makes use of Application WorksheetFunction to calculate the future value with the built in FV function Call this function FVCFB

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

Question: Create a user-defined function to calculate the future value of an uneven stream of cash flows assuming an interest rate of 7%. Test your formula

Create a user-defined function to calculate the future value of an uneven stream of cash flows assuming an interest rate of 7%. Test your formula using the following cash flows:

Time	1	2	3	4	5
Cash Flow	$200	$300	$100	$400	$500

Use the ForNext loop in your function, and call the function FVCFA.

Still using a ForNext loop, rewrite your function so that it makes use of Application.WorksheetFunction to calculate the future value with the built-in FV function. Call this function FVCFB.

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!

Figure 5-9 is a chromatogram of component XX and internal standard SS. The small peak early in the chromatogram is an unretained component. a. What is the linear velocity if the column length is 100...

Q1. Calculate the future value of each following pattern of cash flows: a) You deposit $12,500 today into a 10 year term deposit. The investment pays a 6.5% annual interest rate, compounding...

4. [3 points] Use the 2018 financial statements and the 2019 projected sales from problem #4 to answer the following questions. a. Calculate the AFN (or excess funds) using the long AFN formula b....

FIN 6406 Excel HW 1 AP You need the excel spreadsheet provided that has financials for a firm. Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the...

15) The present value of a $20,000 perpetuity at a 7 percent discount rate is A) $186,915 B) $285,714 C) $140,000 D) $325,000 16) Find the present value of the following stream of cash flows assuming...

please include functions used to solve each problem. 1. Colin has just inherited $6,000. He would like to use this money to buy his mom Enter answer here >>>>>> Hayley a new scooter costing $7,000...

Can I get the solution for the homework by excel (with formulas)? You need the excel spreadsheet provided that has financials for a firm. 1.Determine the Cash Flow From Assets (FCF), Cash Flow to...

FINC 3301 ASSIGNMENT 2 PART 1 TVM Problems 1. Colin has just inherited $6,000. He would like to use this money to buy his mom Hayley a new scooter costing $7,000 two years from now. If he deposits...

Case study on Hyundai's recall of 82,000 electric cars is one of the most expensive in history New York (CNN Business)Hyundai will recall 82,000 electric cars globally to replace their batteries...

You need to create an excel spreadsheet that answers the following questions. Where stated, make sure you solve the problem by hand, i.e. discounting each cash flow, and also using TVM formulas from...

A Rankine oval 2 m long and 1 m high is immersed in a stream U∞ = 10 m/s, as in Fig. P8.37. Estimate (a) the velocity at point A and (b) the location of point B where a particle approaching the...

Find the Tangent vector, the Normal vector, and the Binormal vector (T, N and B) for the curve r(t) = (5 cos (2t), 5 sin(2t), 2t) at the point t = 0 T(0) = (0) - B(0) =

Each of the cards describes a sequence of decimal numbers. a Work out the fifth term of each sequence. b Write the numbers from part a in order of size, starting with the smallest. A First term: 0.5...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

What are the risk management exposures revealed in the case? And, how might these be addressed?

Identify each of the parties affected by events reported in the case.

Is SHRD compatible with individual career aspirations