

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 2
This page cannot be seen from the preview
Don't miss anything!
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?