Question
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. The attached document 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)
Assignment Document 2 - Scarch - 0 X Comments Page Layout Formulas Data Review View Help AutoSave CH H File Home Insert X Out Paste to Copy Format Painter Clipboard Nial 10 = = AA A Wrap Text Merge Center siuting may SME Share AutoSum 47 0 42 Sort & Find & Ideas Clear Filter Select sabing BI O $ Insert Delete Format Sensitivity % Number Conditional Format as Cell Formatting Table Styles *0 Font Alignment Cels deas Sentity 1 Bonza Juice Pty Ltd 2 150000.00 170000.00 176000.00 182300.00 3 Year 4 Pro Forma Income Statement 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.00 -60000.00 27275.92 8182.78 13 68,180.00 81,620.00 15,254.40 19,093.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 Calculations -1000.00 300.00 103,180.00 75,254.40 -237500.00 -20000.00 -258200.00 -10000.00 93180.00 116,620.00 -1400.00 -4000.00 111220.00 -1200.00 74054.40 79,093.14) 49000.00 35200.00 163293.14 Display Settings - 1 + 130% E1 A 523 PM Type here to search e ENG 5/05/2020 Assignment Document 2 - Scarch siuting may SME - 0 X Comments Page Layout Formulas Data Review View Help Share AutoSave CH H File Home Insert X Out Format Painter tak Clipboard 10 AA = = S Nial BIU. Wrap Text Merge Center - 3 Insert Delete Format A General $ $ -% 0 , Number AutoSum" AY O Sort & Find & Clear Filter Select S P Conditional Formatas Cell Formatting Table Styles Styles Ideas 60 00 * 8 Sensitivity Font Alignment Cels Eating das Sensitity E F 74054. 40 Total project cash flows -258200.00 93180.00 111220.00 1 63293.14 Summary and NPV calculations 29 Total NPV 102243.11 31 Internal rate of return 23% 33 Payback Period 2.73 35 Accept/Reject Project Accept Because NPV is positive and IRR is greater than required return of 8% 37 Workings Old Machine 200000 New Machine 300000 75000 39 Purchase price 40 estimated life 41 annual depreciation 42 Book value at time of sale 43 Selling price 44 After tax salvage value 40000 80000 55000 62500 70000 49000 46 Cumulative cash flows -258200.00 - 165020.00 -53800.00 20254.40 Calculations Display Settings - + 100% E1 A 1 5:23 PM 5/05/2020 Type here to search ENG Assignment Document 2 - Scarch - 0 X Comments Page Layout Formulas Data Review View Help AutoSave CH H File Home Insert X Out Paste to Copy Format Painter Clipboard Nial 10 = = AA A Wrap Text Merge Center siuting may SME Share AutoSum 47 0 42 Sort & Find & Ideas Clear Filter Select sabing BI O $ Insert Delete Format Sensitivity % Number Conditional Format as Cell Formatting Table Styles *0 Font Alignment Cels deas Sentity 1 Bonza Juice Pty Ltd 2 150000.00 170000.00 176000.00 182300.00 3 Year 4 Pro Forma Income Statement 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.00 -60000.00 27275.92 8182.78 13 68,180.00 81,620.00 15,254.40 19,093.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 Calculations -1000.00 300.00 103,180.00 75,254.40 -237500.00 -20000.00 -258200.00 -10000.00 93180.00 116,620.00 -1400.00 -4000.00 111220.00 -1200.00 74054.40 79,093.14) 49000.00 35200.00 163293.14 Display Settings - 1 + 130% E1 A 523 PM Type here to search e ENG 5/05/2020 Assignment Document 2 - Scarch siuting may SME - 0 X Comments Page Layout Formulas Data Review View Help Share AutoSave CH H File Home Insert X Out Format Painter tak Clipboard 10 AA = = S Nial BIU. Wrap Text Merge Center - 3 Insert Delete Format A General $ $ -% 0 , Number AutoSum" AY O Sort & Find & Clear Filter Select S P Conditional Formatas Cell Formatting Table Styles Styles Ideas 60 00 * 8 Sensitivity Font Alignment Cels Eating das Sensitity E F 74054. 40 Total project cash flows -258200.00 93180.00 111220.00 1 63293.14 Summary and NPV calculations 29 Total NPV 102243.11 31 Internal rate of return 23% 33 Payback Period 2.73 35 Accept/Reject Project Accept Because NPV is positive and IRR is greater than required return of 8% 37 Workings Old Machine 200000 New Machine 300000 75000 39 Purchase price 40 estimated life 41 annual depreciation 42 Book value at time of sale 43 Selling price 44 After tax salvage value 40000 80000 55000 62500 70000 49000 46 Cumulative cash flows -258200.00 - 165020.00 -53800.00 20254.40 Calculations Display Settings - + 100% E1 A 1 5:23 PM 5/05/2020 Type here to search ENGStep 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