Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can I get any support how to answer cash budget assignment? How can I include Research, overseas trips and legal expenses of preliminary expenses over
Can I get any support how to answer cash budget assignment?
How can I include Research, overseas trips and legal expenses of preliminary expenses over the life of the project with the tax deduction in the year the expense is paid?
Is it the new contract manufaturing sales include whole relevant cash flows?
How can I show the discounted cash flow analysis of capital budget for the base case project for the full six years?
how can I calculate the NPV and the IRR of the project with relevant incremental after tax cash flows?
Data Generation Spreadsheet Student Instructions: In order to generate your personalised data for the assignment, you should enter 1. The fifth digit of your student number in cell D2 2. The sixth digit of your student number in cell E2 3. The seventh digit of your student number in cell F2 4. The eighth digit of your student number in cell G2 (All four digits are all initially set at 0 ) Once your personalised data is generated, you should copy it to a separate workbook for use in your calculations Sales Forecasts Years 1 to 3 New Product Contract Manufacturing 1 2,220,000 390,000 2,610,000 2 2,720,000 440,000 3,160,000 1 -666,000 -97,500 -763,500 2 -816,000 -110,000 -926,000 1 -332,370 0 -173,667 -375,000 -55,333 -100,000 -150,000 -7,669 -1,194,039 2 -402,120 -15,000 -173,667 -375,000 -55,333 -102,000 -150,000 -7,669 -1,280,789 652,461 953,211 1 -715,000 2 -890,000 1 178,750 2 222,500 Raw Material Costs Years 1 to 3 New Product Contract Manufacturing Variable Factory Overhead 18% Allowance for spare parts Depreciation Advertising Research & development Wages Inventory Repayments on loan Lost Sales of Current Product Years 1 to 3 Current Product Variable Costs for lost Sales of Current Product Years 1 to 3 Current Product Note: That for all the above sales and costs the forecasts for years 4 - 6 only increase by 2% per year to allow for general in Fifth Digit Sixth Digit 0 Seventh Digit Eighth Digit 8 0 4 3 3,470,000 515,000 3,985,000 4 3,539,400 5 3,610,188 6 3,682,392 3,539,400 3,610,188 3,682,392 3 -1,041,000 -128,750 -1,169,750 4 -1,061,820 5 -1,083,056 6 -1,104,718 -1,061,820 -1,083,056 -1,104,718 3 -506,745 -30,000 -173,667 -300,000 -55,333 -104,040 -150,000 -7,669 -1,327,454 4 -445,964 -30,600 -173,667 -150,000 -55,333 -106,121 -150,000 -7,669 -1,119,354 5 -454,884 -31,212 -173,667 -150,000 -55,333 -108,243 -150,000 -7,669 -1,131,008 6 -463,981 -31,836 -173,667 -150,000 -55,333 -110,408 -150,000 -7,669 -1,142,895 1,487,796 1,358,226 1,396,124 1,434,780 3 -1,140,000 4 5 6 3 285,000 4 5 6 ur student number in cell D2 our student number in cell E2 f your student number in cell F2 your student number in cell G2 initially set at 0 ) or use in your calculations by 2% per year to allow for general inflationStep 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