Question

In: Finance

Purpose of Assignment  The purpose of this assignment is to allow the students to understand and...

Purpose of Assignment 
The purpose of this assignment is to allow the students to understand and practice the measurement of present value, future value, and interest rate using Microsoft® Excel®. 

Assignment Steps 

Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template

Calculate the following time value of money problems using Microsoft® Excel®:

If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years?


What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent?


If you bought a stock for $45 dollars and could sell it fifteen years later for three times what you originally paid. What was your return on owning this stock?


Suppose you bought a house for $3,250,000 to make it a nursing home in the future. But you have not committed to the project and will decide in nine years whether to go forward with it or sell off the house. If real estate values increase annually at 1.5%, how much can you expect to sell the house for in nine years if you choose not to proceed with the nursing home project?


If your daughter wants to earn $215,000 within the next twenty-three years and the salaries grow at 4.45% per year. What salary should she start to reach her goal?

Solutions

Expert Solution

1]

This is calculated using FV function in Excel :

rate = 7.5%

nper = 9.5

pmt = 0 (annual deposit into the account is zero)

pv = -8592 (initial deposit into account. this is entered with a negative sign because it is a cash outflow)

FV is calculated to be $17,079.48

2]

This is calculated using PV function in Excel :

rate = 3.5%

nper = 13.5

pmt = 0 (annual amount received is zero)

fv = 992 (amount receivable at end of 13.5 years)

PV is calculated to be $623.47

3]

Return is calculated using RATE function in Excel :

nper = 15

pmt = 0 (annual amount received/paid is zero)

pv = -45 (amount paid to buy stock today.  this is entered with a negative sign because it is a cash outflow)

fv = 45 * 3 (amount received after 15 years)

RATE is calculated to be 7.60%

4]

This is calculated using FV function in Excel :

rate = 1.5%

nper = 9

pmt = 0 (annual amount received/paid is zero)

pv = -3250000 (cost of house. this is entered with a negative sign because it is a cash outflow)

FV is calculated to be $3,716,017.42

5]

This is calculated using PV function in Excel :

rate = 4.45%

nper = 23

pmt = 0 (annual amount received/paid is zero)

fv = 215000 (salary required after 23 years)

PV is calculated to be $78,894.93


Related Solutions

Purpose of Assignment The purpose of this assignment is to allow the students to become familiar...
Purpose of Assignment The purpose of this assignment is to allow the students to become familiar with and practice the measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft® Excel®. Assignment Steps Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00)...
Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research...
Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool, Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Select a Fortune 500 company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing Mining Review...
Objective: The objective of this assignment is to allow students to understand the basic principles of...
Objective: The objective of this assignment is to allow students to understand the basic principles of arrays Program Requirements: The assignment will require the students use arrays to perform mathematical calculations. Program Setup: Functions to include in the program The program will have three functions Function 1: Responsible for setting values in the arrays Function 2: Responsible for printing values in arrays Function 3: Responsible for doing calculations to arrays Function 1 Details: Setting array values Parameters: 3 Array of...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data sets to apply the concepts of sampling distributions and confidence intervals to make management decisions. Assignment Steps Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set Review the Payment Time Case Study and Data Set. Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill...
The purpose of this assignment is to allow the student an opportunity to explain what it...
The purpose of this assignment is to allow the student an opportunity to explain what it means to have an efficient capital market. Students will gain an understanding of the different levels of market efficiency and how behavioral finance can inhibit reaching market transparency. Explain in 525 words what it means to have efficient capital market, including: Describe the behavioral challenges in achieving efficiency. Discuss the three forms of market efficiency. What are the implications to corporate finance? Would you...
PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on...
PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on the environmental engineering and sustainable development for environmental engineering. TASK 1 (DOCUMENTATION) Development in science and technology has increase the level of human lifestyle which leads to technology advancement. However, everything good comes with a price. One of the greatest problems that the world is facing today is that of environmental pollution, increasing with every passing year and causing grave and irreparable damage to...
The purpose of this assignment is to understand the terms import and export, and then explain...
The purpose of this assignment is to understand the terms import and export, and then explain the advantages or disadvantages of buying imports rather than buying domestic products. You could, for instance, write about an imported automobile, stereo, or household appliance that you bought or considered buying. Include all of the following points in your discussion. If you were a retailer, would you want to sell domestically made goods or imported items? Please explain why you made this choice. If...
The purpose of this assignment is to allow you to examine both an in-house software development...
The purpose of this assignment is to allow you to examine both an in-house software development and a commercially purchased software package. Scenario: CSU has a sporting goods shop that sells sports equipment, as well as hiking and camping supplies. The CSU shop owner, Peter, wants to develop a customer-order entry system and has hired your IT consulting firm to advise him about software alternatives. Peter is leaning toward in-house development because he does not want to depend on a...
The purpose of this assignment is to read and understand the difference between front end and...
The purpose of this assignment is to read and understand the difference between front end and back end design of a database application. Steps: Search for articles describing front end and back end design of any application (example, a website). Summarize the concepts and elements for each one. Does the database that holds all the data exist at the front end or the back end? Include the answer in your report.
PURPOSE The purpose of this assignment is to enable students in understanding an organisation’s financial goals...
PURPOSE The purpose of this assignment is to enable students in understanding an organisation’s financial goals through the preparation of functional and cash budgets that together integrate into a business plan. Explain how cash budgets help in: (i) forecasting future needs; (ii) controlling cash expenditure; (iii) evaluation of performance; and (iv) acting as a sound dividend policy.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT