Answer
Assignment | Name: | SID: | Tutorial Time & Day: | Tutor: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Signature: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cash flows at the start | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Machine | - 18,000,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Delivery | - 2,000,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Installation | - 160,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Install tax Deduction | 48,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sell Old Machone | 700,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tax Savings Loss on sale | 30,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
marketing | - 900,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
marketing Tax Benefit | 270,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Working Capital | - 600,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total cash flows at the start | (20,612,000.0) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cash flows over life | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reduced Sales of Challenger | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | - 2,500,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Revenue | 4,000,000 | 6,000,000 | 6,300,000 | 6,615,000 | 6,945,750 | 6,945,750 | 6,945,750 | 6,945,750 | 6,945,750 | 6,945,750 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Electricity | - 300,000 | - 300,000 | - 300,000 | - 300,000 | - 320,000 | - 320,000 | - 320,000 | - 320,000 | - 320,000 | - 320,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Material Costs | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | 104,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Old Depreciation | 200,000 | 200,000 | 200,000 | 200,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New Depreciation | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | - 2,000,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
marketing | - 900,000 | - 900,000 | - 900,000 | - 500,000 | - 500,000 | - 500,000 | - 500,000 | - 500,000 | - 500,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tax | 418,800 | - 181,200 | - 271,200 | - 485,700 | - 518,925 | - 518,925 | - 518,925 | - 518,925 | - 518,925 | - 668,925 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sum | - 977,200 | 422,800 | 632,800 | 1,133,300 | 1,210,825 | 1,210,825 | 1,210,825 | 1,210,825 | 1,210,825 | 1,560,825 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
add back depreciation | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
Working Capital | 0 | 600,000.00 | 900,000.00 | 945,000.00 | 992,250.00 | 1,041,862.50 | 1,041,862.50 | 1,041,862.50 | 1,041,862.50 | 1,041,862.50 | 1,041,862.50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Change | 600,000.00 | (300,000.00) | (45,000.00) | (47,250.00) | (49,612.50) | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total cash flows over the life | 522,800 | 2,177,800 | 2,385,550 | 2,883,688 | 3,210,825 | 3,210,825 | 3,210,825 | 3,210,825 | 3,210,825 | 3,560,825 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cash flows at the end | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Salvage Value | 6,000,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tax Benefit | - 1,800,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Working Capital At end | 1,041,863 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total cash flows at end of project | 5,241,863 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Summary and NPV calculations | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cash flows | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
At start | (20,612,000.0) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Over the life | 522,800.0 | 2,177,800.0 | 2,385,550.0 | 2,883,687.5 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 3,560,825.0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
At the end of the project | 5,241,862.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total cash flows | (20,612,000.0) | 522,800.0 | 2,177,800.0 | 2,385,550.0 | 2,883,687.5 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 3,210,825.0 | 8,802,687.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Payback | -20,089,200.0 | -17,911,400.0 | -15,525,850.0 | -12,642,162.5 | -9,431,337.5 | -6,220,512.5 | -3,009,687.5 | 0.9374 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Required rate of return | 10.7% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(20,612,000.0) | 472,160.76 | 1,776,342.13 | 1,757,322.45 | 1,918,516.06 | 1,929,248.59 | 1,742,378.49 | 1,573,608.94 | 1,421,186.67 | 1,283,528.26 | 3,178,032.94 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total NPV | - 3,559,674.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accept/Reject Project | Reject | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Payback Period | 7.9374 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Internal rate of return | 7.4% |
Sheet1
200000 |
Sydney Harbour Fuel
Sydney Harbour Fuel | ||||||||||||
Note that the figures below have the sign (+ or -) as is given in the Net Income or CFFA equations. So for example, CapEx: new vessels is negative not because we sold the boats, we bought them. | ||||||||||||
It's made negative since CapEx is subtracted from CFFA. This means that total CFFA can simply be summed rather than subtracted. Doing it this way is fine, but you can also take the sign of the number into account in the total which is fine too. For example, you could have a positive CapEx, and subtract that number from total CFFA. | ||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flows at the start | ||||||||||||
CapEx: New Vessels | (32,000,000.00) | |||||||||||
Working Capital | (1,100,000.00) | |||||||||||
Retrnechment | (70,000.00) | |||||||||||
Sell Old Boats | 1,920,000.00 | |||||||||||
Book value of old boats according to tax office | 4,600,000.00 | |||||||||||
Tax on Salvage Sale | 804,000.00 | |||||||||||
Total cash flows at the start | (30,446,000.0) | |||||||||||
assumes that renovated barges aren't replaced | ||||||||||||
NI over life | ||||||||||||
Revenue - Light Diesel | 2,000,000.00 | 2,000,000.00 | 2,000,000.00 | 6,000,000.00 | 6,000,000.00 | 10,000,000.00 | 10,000,000.00 | 10,000,000.00 | 10,000,000.00 | 10,000,000.00 | ||
Revenue - heavy Deiesel | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | 20,000,000.00 | ||
Lost petrol Revenue | (4,000,000.00) | (4,000,000.00) | (4,000,000.00) | (2,000,000.00) | (2,000,000.00) | |||||||
Old Depreciation | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 800,000.00 | 800,000.00 | |||||||
Salvage | (200,000.00) | (400,000.00) | ||||||||||
Depreciation New Barges | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | (3,200,000.00) | ||
Insurance | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | ||
Wages Saved | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | 200,000.00 | ||
NI before tax | 16,002,000.00 | 16,002,000.00 | 15,802,000.00 | 21,802,000.00 | 21,402,000.00 | 27,002,000.00 | 27,002,000.00 | 27,002,000.00 | 27,002,000.00 | 27,002,000.00 | ||
Tax | (4,800,600.00) | (4,800,600.00) | (4,740,600.00) | (6,540,600.00) | (6,420,600.00) | (8,100,600.00) | (8,100,600.00) | (8,100,600.00) | (8,100,600.00) | (8,100,600.00) | ||
Cash flows over life | ||||||||||||
Add back Depreciation | 2,200,000.00 | 2,200,000.00 | 2,200,000.00 | 2,400,000.00 | 2,400,000.00 | 3,200,000.00 | 3,200,000.00 | 3,200,000.00 | 3,200,000.00 | 3,200,000.00 | ||
Note that the other items in CFFA are zero so we only add back depreciation here. | ||||||||||||
Total cash flows over the life | 13,401,400.00 | 13,401,400.00 | 13,261,400.00 | 17,661,400.00 | 17,381,400.00 | 22,101,400.00 | 22,101,400.00 | 22,101,400.00 | 22,101,400.00 | 22,101,400.00 | ||
Cash flows at the end | ||||||||||||
Salvage Value | 3,360,000.00 | |||||||||||
Working capital | 1,100,000.00 | |||||||||||
Total cash flows at end of project | 4,460,000.0 | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
Summary and NPV calculations | ||||||||||||
Cash flows | ||||||||||||
At start | (30,446,000.0) | |||||||||||
Over the life | 13,401,400.0 | 13,401,400.0 | 13,261,400.0 | 17,661,400.0 | 17,381,400.0 | 22,101,400.0 | 22,101,400.0 | 22,101,400.0 | 22,101,400.0 | 22,101,400.0 | ||
At the end of the project | 4,460,000.0 | |||||||||||
(30,446,000.0) | 13,401,400.0 | 13,401,400.0 | 13,261,400.0 | 17,661,400.0 | 17,381,400.0 | 22,101,400.0 | 22,101,400.0 | 22,101,400.0 | 22,101,400.0 | 26,561,400.0 | ||
Cumulative cash flows to calculate payback period | Payback | (30,446,000.0) | (17,044,600.0) | (3,643,200.0) | 0.275 | |||||||
Required nominal rate of return (assumed that it is after tax) | 12.500% | |||||||||||
Required real rate of return (assumed that it is after tax) | 7.143% | |||||||||||
PV (cash flows) | (30,446,000.0) | 11,912,355.6 | 10,588,760.5 | 9,313,905.1 | 11,025,925.1 | 9,645,442.2 | 10,901,961.7 | 9,690,632.6 | 8,613,895.6 | 7,656,796.1 | 8,179,480.8 | |
Total NPV | 67,083,155.1 | $67,083,155.15 | ||||||||||
Note that we're using the 'textbook' method of valuation since we discount unlevered CFFA using the after-tax WACC. | ||||||||||||
Accept/Reject Project | Accept | |||||||||||
Payback Period | 2.2747 | |||||||||||
Internal rate of return | 48.9% |
Sheet1
time | 0 | 1 | 2 | 4 |
barges | 5 | 6 | 7 | 5 |
cost | 2000000 | 2000000 | 2000000 | 2000000 |
10000000 | 12000000 | 14000000 | 10000000 | |
r | 0.1 | |||
PV(cash flows) | 10000000 | 10909090.9090909 | 11570247.9338843 | 6830134.55365071 |
Answer
Assignment | Name: | SID: | Tutorial Time & Day: | Tutor: | ||||||||
Signature: | ||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flows at the start | ||||||||||||
Total cash flows at the start | ||||||||||||
Cash flows over life | ||||||||||||
Total cash flows over the life | ||||||||||||
Cash flows at the end | ||||||||||||
Total cash flows at end of project | ||||||||||||
Summary and NPV calculations | ||||||||||||
Cash flows | ||||||||||||
At start | 0.0 | |||||||||||
Over the life | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
At the end of the project | 0.0 | |||||||||||
Total cash flows | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
Required rate of return | ||||||||||||
Total NPV | ||||||||||||
Accept/Reject Project | ||||||||||||
Payback Period | ||||||||||||
Internal rate of return |
1(2)
AFIN 253 Financial Management
Due: Monday 22nd October 12 Noon
This assessment is worth 20% of your final grade.
Viking Boats Pty Ltd
Bob Bradley is the owner and founder of Viking Boats Pty Ltd. Viking is a world leader in the production of luxury motor cruisers. Given the current focus surrounding pollution and global warming, Mr Bradley is considering the development of a hybrid luxury boat that will be able to be powered by diesel and electricity. Despite the expected success of the project, costs are expected to be quite large for the company, as it will require a great deal of new production equipment. Whilst the existing equipment can be used for the production of the boat hulls new machinery will be required for engine production. This new engine production machinery is expected to have an economic life of ten years, although Bob’s accountant believes it may well be still in good working order in 15 years. With this in mind the accountant says he will depreciate it over the full 15 years to dissipate these expenses over a longer period. He has recommended that any project evaluation also use this 15 year timeframe. It would cost Viking Boats $18,000,000 to purchase the machinery, $2,000,000 to have it delivered and a further $160,000 to have it installed. The installation costs are immediately tax deductible. The company has also spent $200,000 on a research report prepared by Olympic sailing gold medallist Tom Slingsby. This is also an allowable tax deduction. The taxation department has stated in a letter to Viking Boats that they will allow the equipment to be depreciated over its economic life of ten years on a straight-line basis. It is expected that current staff will not require any additional training. Given your success in Afin 253 Financial Management while studying at Macquarie University they have decided to employ you as an outside consultant to determine what would be the correct course of action for them to take. It is anticipated that if they produce this new boat that it will overlap with their existing Challenger range of mid size cruisers. This will mean that they can downsize to a smaller number of manufacturing machines for the Challenger and will sell one of their older machines. It would be most profitable to sell the 16 year old machine that originally cost $4,000,000 and should be able to be sold for $700,000. The tax allowable depreciation rate for this type of machinery hasn’t changed over the last 40 years; it is straight line down to zero value over 20 years. The waters around the Viking Boats factory are populated by a number of sharks due to the nearby tuna canning factory. Often boat trials result in capsizes of test models. To prevent this they have for many years employed James Theodore to scare away the sharks using high intensity lasers. James is paid $10,000 per year and will continue to be employed on this wage for many years to come. The new machine is expected to have a salvage value of $6,000,000 at the end of the projects’ economic life in year 10. The sales department believe the reduced sales from the Challenger will amount to around $2,500,000 p.a. for the life of the project.
2(2)
Revenue from sales of the new boat is expected to be $4,000,000 in year one and $6,000,000 in year 2. The revenue will increase by 5% per annum between years 3 and 5 then remain flat for the rest of the project's life. Electricity costs are expected to increase by $300,000 pa in years 1 to 4 and $320,000 pa in years 5 to 10 Material costs are expected to decrease by $104,000 pa. Head office costs of $10,000 are to be allocated from the existing Challenger production to the new boat. These are of course fully tax deductible. Given the size of the project it is expected that Viking Boats will borrow $20,000,000 at a government subsidised interest rate of 3.5%. Interest expense is tax deductible of course. Marketing costs are expected to be $900,000 in years 0 to 3 and $500,000 in years 4 to 9. Due to the increased production there will be an increase in the working capital requirements for the time the new machine is in use. This increase is expected to be 15% of the following year's increase in revenues. Assume that all amounts above are paid at the end of the year. The after-tax WACC used for projects of similar risk is 7.5%, given as a real rate. Treasury bonds yield around 4.5% p.a and pay semi-annual coupons of 8% pa. The firm's bonds pay semi-annual coupons of 5% pa and trade at a yield of 6% pa. The ASX200 trades at a 7% p.a. premium. All of the above rates are nominal rates except for the after-tax WACC, which is a real rate. The company tax rate is 30%. The firm maintains a constant debt to equity ratio of 40%. Inflation is expected to stay at 3% pa. All of the cash flows given are nominal. You are required to submit the following;
1. One page readable spreadsheet downloaded from iLearn clearly showing the NPV, Required Rate of Return, Payback Period and Internal Rate of Return of the project and all other calculations that are used to support your decisions. (20 marks)
Note: Questions about the assignment can only be asked via the discussion board in iLearn. Tutors and lecturers will not answer student questions as they relate to the assignment. Only one page should be submitted to BESS before the due date and time. Do not submit using more than one page and/or plastic sheets etc.
Damian Bridge� 10/10/12 11:56 AM Formatted: Font color: Red, Strikethrough

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com