SLP Financial decision making (Other (Not Listed) Sample)
Financial decision making
As we have said, assessment of financial decisions is an area in which the math matters a great deal. Accordingly, the project for this module features some calculations you're being asked to make, in order to demonstrate to us and to yourself that you understand where the numbers come from and where they are going. The kinds of calculations you're making here are the kinds of calculations that financial managers make all the time, and will wave in your face at the slightest provocation. Being able to speak the math back to them will come in handy on more than one occasion in your careers down the road.
Here are several resources that talk about the time value of money and how to perform net present value calculations EconEd, Study Finance, Discounted Cash Flow. Net present value is often used to inform investment decisions. To perform the calculation, you can follow the formulas as they are presented in the readings or you can simply multiplying the future sum by the appropriate discount factor using theNet Present Value Table.
Please perform the following kinds of calculations, and write a short report describing what you did, showing your figures, and the results that you obtained.
Note: You may use an Excel spreadsheet in order to perform the necessary computations for this questions.
-
Suppose your bank account will be worth $4,200.00 in one year. The interest rate (discount rate) that the bank pays is 5%. What is the present value of your bank account today?
-
Suppose you have two bank accounts, one called Account A and another Account B. Account A will be worth $3,800.00 in one year. Account B will be worth $6,500.00 in two years. Both accounts earn 5% interest. What is the present value of each of these accounts? What is the combined present value of the two accounts?
-
Suppose you just inherited an oil well. This oil well is believed to have three years worth of oil left before it dries up. Here is how much income this oil well is projected to bring you each year for the next three years:
Year 1: $125,000
Year 2: $258,000
Year 3: $310,000
Compute the present value of this stream of income using a discount rate of 7%. Remember, you are calculating the present value for a whole stream of income, i.e. the total value of receiving all three payments (how much you would pay right now to receive these three payments in the future). Your answer should be one number - the present value for this oil well at a 7% discount rate.
SLP Assignment Expectations
Use information from the modular background readings as well as any good quality resource you can find. Please cite all sources and provide a reference list at the end of your paper.
LENGTH: 1-2 pages typed and double-spaced.
The following items will be assessed in particular:
-
Your ability to correctly calculate present value.
SLP Financial Decision Making
Name:
Subject:
Date of Submission
Suppose your bank account will be worth $4,200.00 in one year. The interest rate (discount rate) that the bank pays is 5%. What is the present value of your bank account today?
In order to calculate the present value of $4200, Microsoft Office Excel was used. The cells in Column A were labeled to identify the variable in in column B. Thus, cell A1 was labeled as Time in Years, A2, the discount rate, A3 the future value, and A4 as the present value. The values for the variables were typed into the respective cells in B2 as shown below. The present value for $ 4200 was obtained by clicking the fx button in excel and proceeding with the upcoming steps. First, the present value function was selected by searching it in a dialog box that pops up after clicking on the fx button. The period was entered in the Nper cell, discount rate in the rate cell, zero in the Pmt cell, and the future value in the FV cell (Holden, 2004). The type cell was left blank. This resulted in a present value of 4000 as shown in table 1 below.
Time in Years1Discount Rate5%Future Value4200Present Value($4,000.00)Table SEQ Table \* ARABIC 1
Suppose you have two bank accounts, one called Account A and another Account B. Account A will be worth $3,800.00 in one year. Account B will be worth $6,500.00 in two years. Both accounts earn 5% interest. What is the present value of each of these accounts? What is the combined present value of the two accounts?
The present values for $3800 and $65000 were calculated using Microsoft Excel. Cell A2 was labeled as Time in Years, A3, the discount rate, A4 the future value, and A5 as the present value. Column A and column B included the values for account A and account B respectively while column C was labeled the combined account. The present value for $ 3800 was obtained by clicking the fx button in excel and proceeding with the upcoming steps. First, the present value function was selected by searching it in a dialog box that pops up after clicking on the fx button. The period (one year) was entered in the Nper cell, discount rate in the rate cell (5%), zero in the Pmt cell, and the future value in the FV cell. The type cell was left blank. This resulted in a present value of 3,619.05.
Similarly, present value for $ 6500 was obtained by clicking the fx button in excel and proceeding with the following steps. The present value function was selected by searching it in a dialog box that pops up after clicking on the fx button. The period (one years) was entered in the Nper cell, discount rate in the rate cell (5%), zero in the Pmt cell, and the future value in the FV cell. The type cell was left blank. This resulted in a present value of 5,895.69 (Jeffery, n.d).
In order to find the combined present values for both accounts, the present values for both investments were added together. It was done by clicking on cell D5 using the following function to add the two investments: SUM (B4:C4) (Etheridge, 2010). The results are tabulated as shown in table 2 below.
Account AAccount BCombined AccountTime in Years12Discount Rate5%5%Future Value38006500Present Value($3,619.05)($5,895.69)($9,514.74)Table SEQ Table \* ARABIC 2
Suppose you just inherited an oil well. This oil well is believed to have three years’ worth of oil left before it dries up. Here is how much income this oil well is projected to bring you each year for the next three years:
Year 1: $125,000
Year 2: $258,000
Year 3: $310,000
Compute the present value of this stream of income using a discount rate of 7%. Remember, you are calculating the present value for a whole stream of income, i.e. the total value of receiving all three payments (how much you would pay right now to receive these three payments in the future). Your answer should be one number - the present value for this oil well at a 7% discount rate.
The present values 125,000, 258,000 and 310,000 were calculated using Microsoft Excel. Cell A2 was labeled as Time in Years, A3, the discount rate, A4 the future value, and A5 as the present value. Column A, column B and column C included the values for year one, year two and year three respectively while column D was labeled the combined investment. In order to find the present value for the oil well at year one was calculated using the following procedures.
The present value for $ 1...
Other Topics:
- Information flows and financial managementDescription: Each organization regardless of the size has some form of information flow within and without the organization structure...2 pages/≈550 words| 4 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Financial Ratios Finance PaperDescription: According to Gibson (2009), the return on equity measures how organizations generate income from new investments...2 pages/≈550 words| 3 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Report on Financial Statement Fraud SchemeDescription: The matter that is under investigation involves Eddie Antar who inflated stock price. He had an electronics empire, Crazy Eddie’s Inc....3 pages/≈825 words| 3 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
