Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AFIN 2053 Financial Management Please note that there are two components to this assignment. This assignment is worth 15% of your total grade. Please see

AFIN 2053 Financial Management Please note that there are two components to this assignment. This assignment is worth 15% of your total grade. Please see submission instructions in ilearn. This is a research assignment and requires the use of independent, academic research. In this assignment, you have been lucky enough to get a role as a tutor of Afin 2053. In the attached files is an assignment question and a students answer that unfortunately contains errors. (see attached files Documents 1 and 2) For this assignment you are required to review the assignment answer provided for Jazzy Juices and write a description of each error and why they are in fact errors. Your answer must be concise and contain excellent spelling, grammar and referencing. You will also have to devote one paragraph as a reflection on what you learnt from this process. 1. Ability to identify errors made and the reason for those errors.(10 Marks) 2. Grammar, spelling and referencing style (3 Marks) 3. Depth and Quality of reflection undertaken. (2 marks)

Jazzy Juice Pty Ltd Barry Jazzy is the Managing Director of Jazzy Juice Pty. Ltd. which operates a chain of stores located within major shopping malls. The flagship store is in the Warriewood Shopping Centre on the Northern Beaches of Sydney. The store currently achieves annual sales of $200,000 of fresh fruit juice, $20,000 of canned soft drinks and $15,000 of packaged flavoured milk drinks. Barry is interested in purchasing the Whizzer 2.0 for the Warriewood store, which can produce smoothies in addition to the usual fresh fruit juices. The machine currently sells for $300,000. In order to assess the suitability of the new machine, Barry consulted Barbara Boost from the famous Boost Juice family. Barbara charged $1,000 for her advice. This is immediately fully tax-deductible. The old juicing machine can be sold for $55,000 to a competitor, CarrotnGinger Plus. The new machine has the capacity to increase Jazzy Juices sales of traditional fruit juices to $250,000 per year. This is expected to remain constant forever. Sales of smoothies are expected to be $100,000 in the first year, $120,000 in the second year, and to increase by 5% each year thereafter. It is expected, however, that Jazzy Juice will cease sales of soft drinks and flavoured milk drinks. Assume all cash flows are in nominal terms. Some additional tools will be required to run the Whizzer 2.0 machine. These presently have a cost of $8,000 if purchased new. Barry does however have some of the required tools at his home. These have a book value of $3,000. He is relieved he still has them, as he recently tried to sell them but was not able to attract any buyers. The cash operating costs of the old machine are $75,000 per year. The new machine is more expensive to run. It is expected to have operating costs of $80,000 in the first year and this is expected to increase by 1% each year thereafter due to the extra maintenance involved with high volumes of production. Working capital of $20,000 is required immediately. This is mainly for yoghurt, milk and fruit. Total Net Working Capital at the end of each year will be about 20% of sales for that year. The old machine has an expected life of two years. In two years time the old machine (if it is kept) could be sold to a scrap merchant for about $2,000. The new machine has an expected life of four years and could be sold for $70,000 at the end of four years. The new machine will be depreciated down to zero using the straight-line method. Regarding the new machine, the company plans to 2(3) depreciate it over the estimate life (4 years). However the Australian Taxation Office (ATO) stipulates that for tax purposes the effective life of such machines is 5 years. The accountant has specified that they must follow corporate policy and depreciate over 4 years. The old machine was purchased 3 years ago for $200,000 and Barry has followed the ATO guidelines in determining the depreciation for this machine, assuming a 5 year life. The store currently sublets a portion of their floor space to Barrys friend Susan Spencer, who creates fruit-inspired artwork to sell at local markets. Susan pays rent to Jazzy Juice of $3,000 per year for the space. This is expected to increase by 2% at the end of every year. Susan will immediately be asked to leave the premises so as to fit the new machine. The company plans to borrow $200,000 from the National Juice Lending Authority, which charges an interest rate of 6.3% per annum. This is needed to partially finance the new machine. The interest is tax deductible to the company. The company will make interest-only payments each year, and at the end of the four years will repay the principal of $200,000. The current rate of inflation is 3%. Jazzy Juice pays tax at a rate of 30%. All amounts are in nominal dollars. The real rate of return of the ASX200 index is 10% pa and the real rate of return required on such projects is 8% pa. All rates are given as effective annual rates. 3(3) Questions Prepare a report in Spreadsheet form detailing: (a) A pro forma income statement for the project. (8 marks) (b) Calculation of Operating Cash Flows. (2 marks) (c) Calculation of Net Capital Spending. (6 marks) (d) Calculation of the annual change in Net Working Capital. (5 marks) (e) Calculation of the total project cash flows. (1 mark) (f) Calculation of the net present value of the cash flows. (2 marks) (g) Calculation of the internal rate of return on the project. (2 marks) (h) Calculation of the payback period of the project. (2 marks) (i) Whether Jazzy Juice should proceed with the purchase of the new machine, clearly outlining your reasons. (2 marks)

image text in transcribedimage text in transcribed

AutoSave Of H 2 Assignment Document 2 - Excel S earch Thy Nguyn An (3 - Share 0 x 1 Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot A17 : x fic B C D E F G LA | 1 Bonza Juice Pty Ltd 2 3 Year 150000.00 170000.00 176000.00 182300.00 5 Incremental Sales 6 less costs 7 operating costs of new machine 8 Interest Expense 9 cost savings of old machine 10 less incremental depreciation 11 Earnings before tax (EBT) 12 less tax -80000.00 -12600.00 75000.00 -35000.00 97400.00 29220.00 -80800.00 - 12600.00 75000.00 -35000.00 116600.00 34980.00 -81608.00 - 12600.00 0.00 -60000.00 21792.00 6537.60 -82424.08 - 12600.00 0.001 -60000.00 27275.92 8182.78) 13 68,180.00 81,620.00 15,254.40 19,093.14 -1000.00 300.00 14 15 16 Net Income 17 18 Project Cash Flows 19 Boost Juice Advice 20 Tax on advice 21 Operating Cash Flows 22 Net Capital Spending 23 Change in Net Working Capital 24 Total project cash flows 25 26 Calculations 103,180.00 75,254.40 -237500.00 -20000.00 -258200.00 116,620.00 -1400.00 -4000.00 111220.00 79,093.14 49000.00 35200.00 163293.14 -10000.00 93180.00 -1200.00 74054.40 -- 120% - + 6:59 PM 4/20/2020 ? A ^ . 1)) ENG 3 AutoSave Of H 2 Assignment Document 2 - Excel S earch | A Thy Nguyn - - 1 Share 3 x Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot B C D 117 : * r five A 25 26 27 Summary and NPV calculations 28 29 Total NPV 102243.11 30 23% 2.73 Accept Because NPV is positive and IRR is greater than required return of 8% Old Machine 200000 New Machine 300000 31 Internal rate of return 32 33 Payback Period 34 35 Accept/Reject Project 36 37 Workings 38 39 Purchase price 40 estimated life 41 annual depreciation 42 Book value at time of sale 43 Selling price 44 After tax salvage value 45 46 Cumulative cash flows 47 48 49 75000 40000 80000 55000 62500 70000 49000 -258200.00 - 165020.00 -53800.00 20254.40 50 51 Calculations 0 0 120% @ op -- - + - 7:00 PM ) ENG 4/20/2020 ^ 3 AutoSave Of H 2 Assignment Document 2 - Excel S earch Thy Nguyn An (3 - Share 0 x 1 Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot A17 : x fic B C D E F G LA | 1 Bonza Juice Pty Ltd 2 3 Year 150000.00 170000.00 176000.00 182300.00 5 Incremental Sales 6 less costs 7 operating costs of new machine 8 Interest Expense 9 cost savings of old machine 10 less incremental depreciation 11 Earnings before tax (EBT) 12 less tax -80000.00 -12600.00 75000.00 -35000.00 97400.00 29220.00 -80800.00 - 12600.00 75000.00 -35000.00 116600.00 34980.00 -81608.00 - 12600.00 0.00 -60000.00 21792.00 6537.60 -82424.08 - 12600.00 0.001 -60000.00 27275.92 8182.78) 13 68,180.00 81,620.00 15,254.40 19,093.14 -1000.00 300.00 14 15 16 Net Income 17 18 Project Cash Flows 19 Boost Juice Advice 20 Tax on advice 21 Operating Cash Flows 22 Net Capital Spending 23 Change in Net Working Capital 24 Total project cash flows 25 26 Calculations 103,180.00 75,254.40 -237500.00 -20000.00 -258200.00 116,620.00 -1400.00 -4000.00 111220.00 79,093.14 49000.00 35200.00 163293.14 -10000.00 93180.00 -1200.00 74054.40 -- 120% - + 6:59 PM 4/20/2020 ? A ^ . 1)) ENG 3 AutoSave Of H 2 Assignment Document 2 - Excel S earch | A Thy Nguyn - - 1 Share 3 x Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot B C D 117 : * r five A 25 26 27 Summary and NPV calculations 28 29 Total NPV 102243.11 30 23% 2.73 Accept Because NPV is positive and IRR is greater than required return of 8% Old Machine 200000 New Machine 300000 31 Internal rate of return 32 33 Payback Period 34 35 Accept/Reject Project 36 37 Workings 38 39 Purchase price 40 estimated life 41 annual depreciation 42 Book value at time of sale 43 Selling price 44 After tax salvage value 45 46 Cumulative cash flows 47 48 49 75000 40000 80000 55000 62500 70000 49000 -258200.00 - 165020.00 -53800.00 20254.40 50 51 Calculations 0 0 120% @ op -- - + - 7:00 PM ) ENG 4/20/2020 ^ 3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Presentation Aids Practicing Your Speech?

Answered: 1 week ago