The group project, Macmillan and Grunski Consulting, consists of two sections. The first part explains the case about discounted cash flow analysis, by answering the given nine questions. The second part discusses the retirement planning.
Sandra Macmillan, one of the founders of Macmillan and Grunski Consulting which provides financial planning services, is now giving a short project to Mary Somkin, the firm¡¯s top secretary. If she can successfully demonstrate her ability and skill of discounted cash flow (DCF) analysis, one of the most important concepts in financial planning, she can expand her role in the firm and broaden her job opportunity.
The project was an actual analysis for Sandra¡¯s current client. The client wants to invest their asset with a goal of achieving enough money to pay for their daughter¡¯s college tuition. There are several options that should be financially analyzed in order to give optimal proposals to the client, considering their other considerations, such as home improvement, borrowing fund, or school selection. The following parts describe the details of financial analysis to get well grounded proposals. In conclusion, some key points, which can be generally applied to all DCF analysis, are extracted and pointed out by answering the given nine questions.
Retirement Planning (Value added materials)
In addition to the case study, the second part of this project discusses about retirement planning, taking the findings of the case study into consideration. The discussion includes the importance of planning after retirement at early stage of our life. Also five guidelines for good retirement plan are addressed at the end.
CASE STUDY SOLUTION
Question 1: Choosing a Discount Rate on debt securities.
Given a discount rate i%, it is straightforward to convert a stream of cash flows into a present value, a FV (FV), or an annuity. For example, the present value of a sum of money M received in N years is worth M/(1+i)N today. However, how do we choose the discount rate? Below main factors must be considered: •
Risks: include default risk, liquidity risk and maturity risk. •
Inflation: how much will inflation reduce the future purchasing power of our money? Each of these factors is used to ¡°discount¡± or diminish the PV of future earnings. => PV of M = M/ (1+r*)N(1+IP)N(1+DRP)N¬ (1+LP)N¬ (1+MRP)N¬ ¬¬¬¬ •
Real risk-free rate of interest provided zero inflation (r*) •
A premium to offset the expected effects of inflation (IP%) •
A default risk premium that offset default risk amount (DRP%) •
A liquidity premium (LP%)
A maturity premium (DRP%)
Since each component is small, PV of M ~ M/(1 + r*+ IP+DRP+LP+MRP)N => the discount rate, in this case, equals to (r*+ IP+DRP+LP+MRP)
Question 2: Let's start with one-year period!
a) & b) The goal is to compute FV of $18,000 after 1 year in case of different annual interest rates.
=PV * (1+i1) = $18,000 * (1+8.4%) = $19,512
=PV * (1+i2) = $18,000 * (1+3.2%) = $18,576
=PV * (1+i3) = $18,000 * (1+16.8%) = $21,024
Implication: given same other factors, the higher the interest rate,the higher the FV. Figure: Relationship between interest rate and FV
c) & d) The goal is to compute Effective Annual Rates when nominal interest rate is compounded in different ways and to compute the resulted FV. Bank
First National Bank
Fre. of Compounding [time]
Implication: provided same other factors, the higher the compounding frequency, the higher the EAR & the FV become. e) In order to be as competitive as offering of Bay State Saving & Loan, which means: FVFNB = FVSBL = $19,577 => $18,000 * (1+ iN/2)^2 =...
Please join StudyMode to read the full document