Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Excel Assignment: Calculating Future Value, Present Value, and Growth Rate, Assignments of Data Compression

An excel assignment that covers various financial calculations, including finding the future value (fv) of an investment, the present value (pv) of a future cash flow, and the growth rate of a population. The assignment consists of several parts, each with its own set of inputs and questions to be answered. The document guides the reader through the process of using excel functions to solve these financial problems. The assignment covers topics such as compound interest, present value, and exponential growth, which are fundamental concepts in finance and economics. By working through this assignment, students can develop their skills in financial analysis and problem-solving using spreadsheet software.

Typology: Assignments

2021/2022

Uploaded on 06/06/2024

jackson-mcclain
jackson-mcclain 🇺🇸

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Chapter 5 Excel Assignment
Inputs: PV = 1000
I/YR = 10%
N = 5
FV ($1,610.51)
b. Now create a table that shows the FV at 0%, 5%, and 20% for 0, 1, 2, 3, 4, and 5 years.
Interest Rate (D9)
($1,610.51) 0% 5% 20%
0
1
2
3
4
5
Inputs: FV = 1000
I/YR = 10%
N = 5
PV
Inputs: PV = -1000
FV = 2000
I/YR = ?
N = 5
Rate
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this
question by using the Excel function
c. Find the PV of $1,000 due in 5 years if the discount rate is 10% per year. Again, work the
problem by using the Excel function
d. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return
does the security provide?
pf2

Partial preview of the text

Download Excel Assignment: Calculating Future Value, Present Value, and Growth Rate and more Assignments Data Compression in PDF only on Docsity!

Chapter 5 Excel Assignment

Inputs: PV = 1000 I/YR = 10% N = 5 FV ($1,610.51) b. Now create a table that shows the FV at 0%, 5%, and 20% for 0, 1, 2, 3, 4, and 5 years. Interest Rate (D9) ($1,610.51) 0% 5% 20% 0 1 2 3 4 5 Inputs: FV = 1000 I/YR = 10% N = 5 PV Inputs: PV = - FV = 2000 I/YR =? N = 5 Rate a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using the Excel function c. Find the PV of $1,000 due in 5 years if the discount rate is 10% per year. Again, work the problem by using the Excel function d. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security provide?

Inputs: PV = - FV = 60 I/YR = growth rate 2% N =? NPER = Years to double. Part a. FV with semiannual compounding: Orig. Inputs New Inputs Inputs: PV = 1000 1000 I/YR = 10% 5% N = 5 10 FV Part c. PV with semiannual compounding: Orig. Inputs New Inputs Inputs: FV = 1000 1000 I/YR = 10% 5% N = 5 10 PV e. Suppose California’s population is 30 million people, and its population is expected to grow by 2% per year. How long would it take for the population to double? f. What would the FV and the PV for parts a and c be if the interest rate were 10% with semiannual compounding rather than 10% with annual compounding?