Estimate revenues from year 1 to year 5 based on the following assumptions: . Current Market...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimate revenues from year 1 to year 5 based on the following assumptions: . Current Market Volume Units: 72,000,000 . Current Unit Price: $6.00+ Annual Estimated Volume Growth Rate: 3%- • Targeted Market Share: o First Year 0.5% - o Second Year 2% o Third Year 4% o Fourth Year 4% o Fifth Year 4% • Accounts Receivable is estimated to be 10% of Sales. Prior to the First Year there were no Sales. . Task 2 Estimate the COGS, Inventories, Purchases and Accounts Payable from year 1 to year 4- • Unit Sales Price is a 60% mark up on the Unit Cost of Goods Sold • You plan to hold Inventories equal to 30% of your estimate for next year's Sales . • You pay for 92% of Purchases in the year in which they were purchased and the remainder in the following year. Inventory at the beginning of the First Year is $1,000,000.- Task 3 Estimate Wage Expense, Accrued Liabilities and Selling and Administrative Expenses from year 1 to year 4 based on the following assumptions: . • Wage Expense equals to 8% of current year Sales • You pay wages monthly in arrears, meaning that you will only pay for eleven of the twelve months wages in the year in which they have been earned and will pay the remaining one month of wages earned in the last month earned in the last month of the current year in the following year. Selling and Administrative Expenses, including rent is estimated to be 10% of sales and is paid in the year in which it occurs . W Task 4: Estimate a projected four-year Income Statement, based on the above assumptions and the following additional assumptions: Depreciation is estimated as being equal to 10% of Gross Fixed Assets at the end of the prior year. . • Interest Expense on Debt is at a rate of 15% per annum and is estimated based on the Debt Balance and Additional Funds Needed (if any) estimated at the end of the prior year. • Tax is estimated as being expensed at 30% of Earnings before Tax. Assume that any tax benefits are NOT carried forward to reduce future tax payable. • Assume NO dividends are declared Task 5+ Estimate a projected four-year Balance Sheet, based on the above assumptions and the following additional assumptions . • The Balance Sheet at the end of the year prior to First Year was comprised as follows: Cash $50.000: Inventories $1,000,000, Gross Fixed Assets $4,000,000; Debt $2,000,000 and Owners Equity $3,050,000. You should assume all other prior period Balance Sheet values were zero. Required cash is estimated to be 1% of Sales • The business requires capital expenditure of $500,000 a year in each of the first two years. • Assume the founder invests additional $2,000,000 in the first year. Task 6 Estimate a projected four-year Cash Flow Statement, based on the above assumptions Task 7 Estimate the sustainable growth rate as at the end of the fourth year, based on the following assumptions • The sustainable Profit Margin is estimated to be equal to that estimated for the fourth year, based on the fourth year Net Income and Sales. The sustainable Asset Turnover is estimated to be equal to that estimated for the fourth year, based on average Total Assets in year 3 and 4 and Sales in year • Assume a target Leverage Ratio as being equal to 120% Assume a target Retention Ratio as being equal to 40%. . I Estimate revenues from year 1 to year 5 based on the following assumptions: . Current Market Volume Units: 72,000,000 . Current Unit Price: $6.00+ Annual Estimated Volume Growth Rate: 3%- • Targeted Market Share: o First Year 0.5% - o Second Year 2% o Third Year 4% o Fourth Year 4% o Fifth Year 4% • Accounts Receivable is estimated to be 10% of Sales. Prior to the First Year there were no Sales. . Task 2 Estimate the COGS, Inventories, Purchases and Accounts Payable from year 1 to year 4- • Unit Sales Price is a 60% mark up on the Unit Cost of Goods Sold • You plan to hold Inventories equal to 30% of your estimate for next year's Sales . • You pay for 92% of Purchases in the year in which they were purchased and the remainder in the following year. Inventory at the beginning of the First Year is $1,000,000.- Task 3 Estimate Wage Expense, Accrued Liabilities and Selling and Administrative Expenses from year 1 to year 4 based on the following assumptions: . • Wage Expense equals to 8% of current year Sales • You pay wages monthly in arrears, meaning that you will only pay for eleven of the twelve months wages in the year in which they have been earned and will pay the remaining one month of wages earned in the last month earned in the last month of the current year in the following year. Selling and Administrative Expenses, including rent is estimated to be 10% of sales and is paid in the year in which it occurs . W Task 4: Estimate a projected four-year Income Statement, based on the above assumptions and the following additional assumptions: Depreciation is estimated as being equal to 10% of Gross Fixed Assets at the end of the prior year. . • Interest Expense on Debt is at a rate of 15% per annum and is estimated based on the Debt Balance and Additional Funds Needed (if any) estimated at the end of the prior year. • Tax is estimated as being expensed at 30% of Earnings before Tax. Assume that any tax benefits are NOT carried forward to reduce future tax payable. • Assume NO dividends are declared Task 5+ Estimate a projected four-year Balance Sheet, based on the above assumptions and the following additional assumptions . • The Balance Sheet at the end of the year prior to First Year was comprised as follows: Cash $50.000: Inventories $1,000,000, Gross Fixed Assets $4,000,000; Debt $2,000,000 and Owners Equity $3,050,000. You should assume all other prior period Balance Sheet values were zero. Required cash is estimated to be 1% of Sales • The business requires capital expenditure of $500,000 a year in each of the first two years. • Assume the founder invests additional $2,000,000 in the first year. Task 6 Estimate a projected four-year Cash Flow Statement, based on the above assumptions Task 7 Estimate the sustainable growth rate as at the end of the fourth year, based on the following assumptions • The sustainable Profit Margin is estimated to be equal to that estimated for the fourth year, based on the fourth year Net Income and Sales. The sustainable Asset Turnover is estimated to be equal to that estimated for the fourth year, based on average Total Assets in year 3 and 4 and Sales in year • Assume a target Leverage Ratio as being equal to 120% Assume a target Retention Ratio as being equal to 40%. . I
Expert Answer:
Answer rating: 100% (QA)
Task 1 Estimate Revenues Assumptions Current Market Volume Units 72000000 Current Unit Price 600 Annual Estimated Volume Growth Rate 3 Targeted Market Share First Year 05 Second Year 2 Third Year 4 Fo... View the full answer
Posted Date:
Students also viewed these finance questions
-
Based on the following scenario, role-play a decision-making meeting using effective communication skills and group decision-making processes. The decision-making role-playing may be conducted as a...
-
Based on the following accounts, calculate (a) Net sales, (b) Cost of goods sold, (c) Gross profit, (d) Net income. Accounts Payable .................. $ 6,400 Operating Expenses .....................
-
Based on the following image: a. Explain where the charges should be applied to this gel in order for the DNA samples to migrate properly. b. Identify the largest DNA fragment in sample 5. Explain...
-
Copper Products Limited leases property on which copper has been discovered. The lease provides for an immediate payment of $472,000 to the lessor before drilling has begun and an annual rental of...
-
Match the following terms and definitions. a. entity b. entity occurrence c. entity attribute d. entity identifier e. candidate key f. parent entity g. child entity h. dependent entity __ 1. In a...
-
Repeat Prob. 7.108 above if the ball is instead struck with underspin, that is, with the front of the ball rotating upward.
-
What is the difference between augmented intelligence and autonomous intelligence?
-
The income from operations and the amount of invested assets in each division of Steele Industries are as follows: a. Compute the rate of return on investment for each division. b. Which division is...
-
A firm is considering a project that has an initial investment of $250,000 and is expected to produce cash inflows of $50,000 per year for 10 years. What is the project's payback period? If the...
-
At June 30, 2022, the end of its most recent fiscal year, Green River Computer Consultants post-closing trial balance was as follows: The company underwent a major expansion in July. New staff was...
-
The balance in the prepaid insurance account, before adjustment at the end of the year, is $18,630. The year end is March 31. Journalize the March 31 adjusting entry required under each of the...
-
Jimmy died on 14 February 2024. He had made the following gifts during his lifetime: (1) On 2 August 2022, he made a cash gift of 50,000 to his grandson. This was a wedding present. (2) On 14...
-
Garfield has been registered for VAT since 1 April 2017. His business is situated in Great Britain. His partly completed VAT computation for the quarter to 31 March 2024 is shown below. The figures...
-
Phoebe made the following transfers during 2023-24: None of the gifts are regarded as normal expenditure out of income. Phoebe made no transfers at all during 2022-23. Calculate the value of each of...
-
On 12 November 2013, Hazel made a gross chargeable transfer to a relevant property trust of 266,000 (after deduction of exemptions). On 1 April 2019 she gave 300,000 to her grandson. These were her...
-
Tony died on 11 July 2023, leaving an estate which was valued at 900,000. None of the transfers made on his death were exempt from IHT. He had made the following transfers during his lifetime:...
-
But the removal of Lee came at a tough time for Samsung, which has been seeking new avenues for growth as sales of its market-leading smartphones seem to be slowing down. A few months later,...
-
Cornell and Roberts are partners who agree to admit Stanley to their partnership. Cornell has a capital balance of $80,000 and Roberts has a capital balance of $120,000. Cornell and Roberts share net...
-
_________ is the satisfaction or enjoyment derived from consumption.
-
The relative satisfaction gained by two people drinking cups of coffee _________ be measured in comparable terms.
-
_________ is the total amount of satisfaction derived from the consumption of a certain number of units of a good.
Study smarter with the SolutionInn App