Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Write a function to calculate the future value of a lump sum called FVCalc(deposit, t, LIBOR). For your three inputs: 1) Deposit will be

1) Write a function to calculate the future value of a lump sum called FVCalc(deposit, t, LIBOR). For your three inputs: 1) Deposit will be the PV today, and 2) time will be equal to the number of periods. We want this function to work like Excel's FV or future value function, except that there will be no payments and therefore no issues with annuity/annuity due. Also, design the program so that PVs and FVs are all positive (since we are only worried about a lump sum). For your third input we will use LIBOR to calculate a variable rate. Specifically, the function will use the LIBOR rate (input by the user as the third parameter above) and will estimate "r" for the future value calculation based on the following rate schedule: -For initial deposits of less than $100, the rate will be LIBOR +0.5% -For initial deposits from $100 up to $1,000, the rate will be LIBOR + 1.1% -For initial deposits from $1,000 up to $10,000, the rate will be LIBOR + 2.5% -For initial deposits from $10,000 up to $100,000, the rate will be LIBOR + 3.6% -For initial deposits $100,000 and up, the rate will be LIBOR + 4.1%
image text in transcribed
1) Write a function to calculate the future value of a lump sum called FVCalc(deposit, t, LIBOR). For your three inputs: 1) Deposit will be the PV today, and 2) time will be equal to the number of periods. We want this function to work like Excel's FV or future value function, except that there will be no payments and therefore no issues with annuity/annuity due. Also, design the program so that PVs and FVs are all positive (since we are only worried about a lump sum). For your third input we will use LIBOR to calculate a variable rate. Specifically, the function will use the LIBOR rate (input by the user as the third parameter above) and will estimate " r " for the future value calculation based on the following rate schedule: -For initial deposits of less than $100, the rate will be LIBOR+0.5% -For initial deposits from $100 up to $1,000, the rate will be LIBOR +1.1% -For in -For initial deposits from $10,000 up to $100,000, the rate will be LIBOR +3.6% -For initial deposits $100,000 and up, the rate will be LIBOR +4.1%

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

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

Finance And Investments Application To South African Financial Markets

Authors: Mthuli Ncube

1st Edition

3843375984, 9783843375986

More Books

Students also viewed these Finance questions