need help Immediately please with step by step answer

Assume an interest rate of 3% c.s.a for the NPV calculation Outgoing funds: (Expenses) 1) Re-Paying back the face value of a $1,000,000 bond 2 years from the start of the project 2) Paying interest coupons semi annually at 1% c.s.a 3) Salaries of staff of $90,000 payable each month 4) Office expenses of $50,000 payable each month 5) Loan payments on a loan of $800,000 at 2% c.s.a. paid semi-annually to be repaid in full in 2 years 6) Initial start up expenses for building and equipment of $700,000 Incoming Funds (Revenues) 1) $1,000,000 bond from investors (referred to it 1) above) 2) $800,000 loan from bank (referred to in 5) above) 3) Revenue from product at $250,000 each half year Make sure to have all documents in PDF format 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. Use landscape orientation to allow for more room. You make use ... notation where repetitions occur There are 9 Funds in all (6 outgoing 3 incoming). Each properly labelled Fund on time Line . 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 3% c.s.a 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. On a separate page from the detailed timeline, clearly Show the value of EACH fund and the corresponding Equation detailing than the value of the fund is determined. Make sure to use each fund and value represented on a timeline with an equation. Make sure to compute the overall value of the incoming and outgoing funds. Also Show equations relating to these totals. c) COMMENT on the value of the project from a financial point of view in a 1-Page typed summary. Add suggestions as to how the financial aspect of the project could be improved. Support your comments Based on Your findings from parts a) and b). The net present value of a project is used to determine its viability. A positive NPV indicates that the company is a financially sound. On the other hand, a negative net present value indicates that the company is not viable. Net present value Summary The project has a negative value of more than three million. The project is not viable due to the negative net present value. From the financial analysis point of view, the company has so many cash outflow channels than inflows. Clearly, this puts the incorporation at losses. Right from the project initial capital expenditure, huge sums of money are used throughout the project life. Recommendations Any organization endeavors to make profits. The revenues generated are the key attributes to the company future prospects. In order to maintain the profitability position, the company must reduce expenses. The management should ensure that the huge monthly expenses, salaries and interest payments are minimized. Secondly, the source of funding has resulted into implicit costs. The interest payments and coupon rates are the reason for budging financial expenses. The management should decide on issuing common stock. Issuing of shares does not result into huge costs like bonds and loans. Lastly, the company must aim at increasing sales revenue. Increased revenues raises profits and cash inflow thereof. Market segmentation, price setting and after sales services are some of marketing techniques to improve sales. Net Present Value Net present value is determined after each year. For the two years, the net cash flows are equal. That is, revenues and expenses are the same. To determine the present value of this cash flow, we multiply net flow with present interest factor. Total net cash flow is ($2,464,000)/2 = ($1,232,000). Present value interest factor is calculated as, PVIF = {(1+r)^-n} Where, r is the discounting rate N is the number of years Year 1. Net present value, $1,232,000*{(1+0.03)^-1} $1,232,000*0.9709 = ($1,196,148) Year 2. Net present value, $1,232,000*{(1+0.03)^-2} $1,232,000*0.9426 = ($1,161,283) The net present value of a project is used to determine its viability. A positive NPV indicates that the company is a financially sound. On the other hand, a negative net present value indicates that the company is not viable. Net present value Summary The project has a negative value of more than three million. The project is not viable due to the negative net present value. From the financial analysis point of view, the company has so many cash outflow channels than inflows. Clearly, this puts the incorporation at losses. Right from the project initial capital expenditure, huge sums of money are used throughout the project life. Recommendations Any organization endeavors to make profits. The revenues generated are the key attributes to the company future prospects. In order to maintain the profitability position, the company must reduce expenses. The management should ensure that the huge monthly expenses, salaries and interest payments are minimized. Secondly, the source of funding has resulted into implicit costs. The interest payments and coupon rates are the reason for budging financial expenses. The management should decide on issuing common stock. Issuing of shares does not result into huge costs like bonds and loans. Lastly, the company must aim at increasing sales revenue. Increased revenues raises profits and cash inflow thereof. Market segmentation, price setting and after sales services are some of marketing techniques to improve sales. Net Present Value Net present value is determined after each year. For the two years, the net cash flows are equal. That is, revenues and expenses are the same. To determine the present value of this cash flow, we multiply net flow with present interest factor. Total net cash flow is ($2,464,000)/2 = ($1,232,000). Present value interest factor is calculated as, PVIF = {(1+r)^-n} Where, r is the discounting rate N is the number of years Year 1. Net present value, $1,232,000*{(1+0.03)^-1} $1,232,000*0.9709 = ($1,196,148) Year 2. Net present value, $1,232,000*{(1+0.03)^-2} $1,232,000*0.9426 = ($1,161,283)