For this section, use workbook Time

For this section, use workbook Time.xlsx. This section is slightly different in that you have to create the formulas in each worksheet and then answer additional questions. For full credit, I need to see the use of the function and formula features of Excel. You must use the appropriate function/formula to earn full credit and the answers must be in the highlighted cells with a surrounding border.

undefined

Definitions

undefined

Cash Flow: Earnings before depreciation, etc.

undefined

Discount Rate: Interest rate

undefined

Future Value: The value of an asset at a certain point in the future when its return is a known factor.

undefined

Period: The time span in which certain financial events took place.

undefined

Present Value: The current worth of a future sum of money or stream of cash flows given a specified rate of return

undefined

Formulas

undefined

FUTURE VALUE

undefined

Annuity Future Value: Equals (Payment) * (((1 + (Discount Rate/Period)) ^ (Number of Periods)) - 1) / (Discount Rate/Period)

undefined

Future Value: Equals (Cash Flow) * ((1 + (Discount Rate/Period)) ^ ((Number of Periods) – (Current Period))

undefined

Future Value of Each Cash Flow: Equals (Cash Flow) * ((1 + (Discount Rate/Period)) ^ ((Number of Periods) – (Current Period))

undefined

LOAN AMORTIZATION

undefined

Beginning Principal Balance in Year T: Equals (Beginning Principal Balance in year t-1) - (Principal Component in year t-1)

undefined

Interest Component in Year T: Equals (Interest rate/year) * (Beginning Principal Balance in year t)

undefined

Principal Component in Year T: Equals (Payment) - (Interest component)

undefined

PRESENT VALUE

undefined

Annuity Present Value: Equals (Payment) * (1 – ((1 + (Discount Rate/Period)) ^ (-Number of Periods))) / (Discount Rate/Period)

undefined

Present Value: Equals (Cash Flow) / ((1 + (Discount Rate/Period)) ^ (Number of Periods))

undefined

Present Value of Each Cash Flow: Equals (Cash Flow) / ((1 + (Discount Rate/Period)) ^ (Period))

undefined

Future Value

undefined

1. A cash flow of $747.25 is available now (in Period 0). For this cash flow, the appropriate discount rate/period is 6.0%. What is the period 5 future value? Use worksheet “Single-FV”.
2. An annuity pays $80.00 each period for 5 periods. For these cash flows, the appropriate discount rate/period is 6.0%. What is the period 5 future value? Use worksheet “Annuity-FV”.

undefined

Present Value

undefined

1. A cash flow of $1,000.00 will be received in period 5. For this cash flow, the appropriate discount rate/period is 6.0%. What is the present value of this single cash flow? Use worksheet “Single-PV”.
2. An annuity pays $80.00 each period for 5 periods. For these cash flows, the appropriate discount rate/period is 6.0%. What is the present value of this annuity? Use worksheet “Annuity-PV”.