Homework answers / question archive / For this section, use workbook Time

For this section, use workbook Time

Business

Share With

---

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”.