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...
-
Describe the differences between the current, quick, and cash ratios. Which one is the most conservative measure of short-term liquidity?
-
Vic Corporation operates entirely in the United States but in different industries. It segments the business based on industry. Total sales of the segments, including intersegment sales, are as...
-
Three parallel-plate capacitors are separately connected to identical batteries. Capacitor 1 has a plate area \(A\) and a plate separation \(d\). Capacitor 2 has a plate area \(2 A\) and a plate...
-
Data pertaining to the current position of Boole Company are as follows:Cash................... $240,000Temporary investments............ 120,000Accounts and notes receivable (net)..........
-
Fluorine Limited (FL), a manufacturer of ships, has entered into the following contracts during the year ended 31 December 2022: (i) On 1 January 2022, FL entered into a contract with Alpha Limited...
-
The information necessary for preparing the 2024 year-end adjusting entries for Bearcat Personal Training Academy appears below. Bearcats fiscal year-end is December 31. 1. At the end of the year,...
-
Under what conditions do the following production functions exhibit decreasing, constant, or increasing returns to scale? a. q = L + K b. q = L^a x K^b c. q = L + L^a x K^b + K
-
State the objectives of audit of government accounts and compare them with those of the audit under the Companies Act.
-
Mention important items for which auditor would refer to each of the following: (a) Minutes book of the Board Meeting (b) Minutes book of the Shareholders Meeting.
-
What is a clean report? Give a specimen of a clean report of the auditor.
-
Discuss the different stages of conducting bank audit.
-
What do you mean by the term computer-assisted audit techniques? State the factors to be considered before using these techniques.
-
You mentioned that Amazon has sustainability topics within us supply chain. How we deal with the criticism that Amazon itself tribute to overconsumption that's antithetical to sustainability
-
A simple random sample of 220 university students were asked what pasta they usually order and with which sauce. The preferences of these respondents are summarised below: Sauce Bolognese Pasta...
-
Refer to the latest financial report of JB Hi-Fi Limited on its website, www.jbhifi.com.au, and answer the following questions. 1. Is it likely that JB Hi-Fi Limited would have to confront such...
-
Imelda Instruments Ltd manufactures two products: missile range instruments and space pressure gauges. During January, 53 range instruments and 360 pressure gauges were produced, and overhead costs...
-
Swiss Chocolates Ltd produces blocks of chocolate. Raw materials in the form of cocoa solids, milk and sugar are added at the beginning of the process, flavouring, fruit and nuts are added half-way...
Study smarter with the SolutionInn App