Question
Assume an interest rate of 6% c.m for the NPV calculation. The entire project is over 1 year. Show FULL details at every time point
Assume an interest rate of 6% c.m for the NPV calculation. The entire project is over 1 year. Show FULL details at every time point where there is a money event occurring. Outgoing funds: (Expenses) 1) Re-Paying back the face value of a $3,000,000 bond repayable 1 year from the start of the project 2) Paying interest coupons quarterly at 4% c.q 3) Salaries of staff of $30,000 payable each Month 4) Office expenses of $4,000 payable each Month 5) Loan payments on a loan of $500,000 at 3% c.q. paid quarterly to be repaid in full in 1 years 6) Initial start up expenses for building and equipment of $600,000 Incoming Funds (Revenues) 1) $3,000,000 bond from investors (referred to it 1) above) 2) $500,000 loan from bank (referred to in 5) above) 3) Revenue from product at $100,000 each month for 1 year
a) A detailed time line of all of the Outgoing funds and Incoming Funds. Use different Colors or styles to distinguish them (Or use outgoing above the line and Incoming below the line). Make Time line readable . Show every month and quarter and yearly values clearly.
There are 9 Funds in all (6 outgoing 3 incoming). Each properly labelled Fund on time Line counts for 4 marks. There is an additional 4 marks for overall Format as demonstrated in the Course. Funds must be clearly labelled showing all relevant Dates. Annuities must be clearly labelled and show individual payments. Use arrows to indicate where funds are being valued.
b) Determine the Net Present Value of the Project at time 0.
Use 6% c.m for this valuation. Show details of the fund. Show the value as Incoming funds minus the outgoing funds using present values of all. Show complete details of all calculations, clearly Show the value of EACH fund and the corresponding Equation detailing than the value of the fund is determined.
Also Show equations relating to these totals.
c) COMMENT on the value of the project from
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started