It's STILL January 1, 2023, and you'll be going on Shark Tank in 2 weeks. You...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It's STILL January 1, 2023, and you'll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast because your current sales to residences do not really predict your upcoming sales to commercial builders. You believe your incoming orders will be much higher than before with each order resulting in a much higher revenue stream. You decide to change your method of forecasting to a mix of Percent-of-Sales and Pro Forma forecasting. Required: 1 (25 pts) Using the information on the Assumptions tab, create a 5-year forecasted Income Statement on the Forecasted Financials tab. The Sharks gave you the $1,000,000 in funding you asked for in exchange for 25% ownership of your company's profits. You issued 26,000 $1-par shares to the Sharks and updated your additional paid- in capital by the excess received. The sharks have a 9% Required Rate of Return on their investment (needed for Milestone 3). All the following are complete by March 31, 2023: 1) your shark funding has been received, 2) new capital investments have been purchased and set up, and 3) additional labor has been hired and trained SALES: a. All Sales are credit sales. b. In 2023, your expanded operations enable Production and Sales to double your 2022 sales (due to selling more windows to the commercial builders and increasing the sale price per window). c. Quantity of windows sold is expected to increase 25% every year from 2024 on. d. Due to inflation and demand, at the start of 2024 you increase your selling price per window by 9%. COGS: Compute your 2022 COGS as a Percent of Sales ratio, and then subtract 10% because you'll be able to get volume discounts for your materials now that you've expanded. Use this adjusted ratio to forecast COGS across all years. SELLING & ADMINISTRATIVE EXPENSE: S&A Expense is a "mixed" expense, so fixed expenses must be removed before forecasting S&A, and then added back once that's done. Use a 3-year average Percent of Sales to forecast variable S&A expenses. (HINT: Recall that since S&A is an expense, and therefore negative, to remove fixed expenses, you must ADD them!) All S&A expenses are variable expenses EXCEPT for the following 2 fixed costs: 1. Rent expense of $15,000 per year in 2020-2022, increasing to $200,000 per year in 2023-2027. 2. Depreciation expense is included in S&A in the amount of 10% of Plant & Equipment each year. INTEREST EXPENSE: This is a Fixed cost, and is 10% of Long-term Liabilities. Guil TAYES. D TAXES: Because you live in a business-friendly State (Wyoming), you don't have to pay state taxes on your LLC's income. You do, however, still have to pay Federal taxes. Also, in 2022, higher tax rates were passed for the 2023 tax year, pushing income over $400,000 into the 39.6% tax bracket. Because of this, use 36% as your effective tax rate. (NOTE: If the taxes shown for 2020-2022 seem high, it's because you had income from another job that threw your LLC income into a slightly higher tax bracket. However, you'll quit that job If the sharks fund you!) SHARES: Issued 72,000 $1-par shares to the sharks for a 48% ownership stake. CASH: Increases to $50,000 in 2023 and stays at that level. MARKETABLE SECURITIES: Plan to keep Marketable Securities at 60% of Cash levels. ACCOUNTS RECEIVABLE: Use a 3-year average Receivables Turnover ratio to forecast. INVENTORY: Compute a 3-year average of inventory as a percent of sales, and then use that figure to forecast inventory levels through 2027. PLANT & EQUIPMENT: New capital expenditure of $750,000 dollars in 2023, paid for with equity funding from the sharks, rather than new debt. All capital expenditures are assumed to occur on January 1st of the year of purchase, and no equipment is sold or salvaged during the forecasted period. ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to the depreciation amount. ACCOUNTS PAYABLE: Use the 3-year average Current Ratio to forecast. ACCRUED EXPENSES: Use the 3-year average Percent of Sales method to forecast. LONG-TERM LIABILITIES: Pay down $100,000 of old debt every year starting in 2023. COMMON STOCK ($1 Par): Increase by the dollar value of shares issued to sharks (26,000 shares at $1 par). CAPITAL PAID IN EXCESS OF PAR: Compute new figure using shark investment, less par value of common stock. RETAINED EARNINGS: Fill in the amount needed to balance the Balance Sheet. DIVIDENDS: You do not pay dividends now and do not plan to while in a growth stage. FIXED & VARIABLE COSTS: The only fixed costs are rent expense, depreciation expense, and interest expense. All other costs are variable. MILESTONE 2 FORECASTED FINANCIALS Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (25 points) Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share 2020 1,200,000 (800,000) 400,000 (304,900) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2022 2021 1,500,000 (1,040,000) 460,000 (350,500) 109,500 (45,000) 64,500 (49,200) 15,300 60,000 $0.26 1,875,000 (1,105,000) 770,000 (443,700) 326,300 (85,000) 241,300 (55,600) 185,700 78,000 $2.38 2023 2024 2025 2026 2027 It's STILL January 1, 2023, and you'll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast because your current sales to residences do not really predict your upcoming sales to commercial builders. You believe your incoming orders will be much higher than before with each order resulting in a much higher revenue stream. You decide to change your method of forecasting to a mix of Percent-of-Sales and Pro Forma forecasting. Required: 1 (25 pts) Using the information on the Assumptions tab, create a 5-year forecasted Income Statement on the Forecasted Financials tab. The Sharks gave you the $1,000,000 in funding you asked for in exchange for 25% ownership of your company's profits. You issued 26,000 $1-par shares to the Sharks and updated your additional paid- in capital by the excess received. The sharks have a 9% Required Rate of Return on their investment (needed for Milestone 3). All the following are complete by March 31, 2023: 1) your shark funding has been received, 2) new capital investments have been purchased and set up, and 3) additional labor has been hired and trained SALES: a. All Sales are credit sales. b. In 2023, your expanded operations enable Production and Sales to double your 2022 sales (due to selling more windows to the commercial builders and increasing the sale price per window). c. Quantity of windows sold is expected to increase 25% every year from 2024 on. d. Due to inflation and demand, at the start of 2024 you increase your selling price per window by 9%. COGS: Compute your 2022 COGS as a Percent of Sales ratio, and then subtract 10% because you'll be able to get volume discounts for your materials now that you've expanded. Use this adjusted ratio to forecast COGS across all years. SELLING & ADMINISTRATIVE EXPENSE: S&A Expense is a "mixed" expense, so fixed expenses must be removed before forecasting S&A, and then added back once that's done. Use a 3-year average Percent of Sales to forecast variable S&A expenses. (HINT: Recall that since S&A is an expense, and therefore negative, to remove fixed expenses, you must ADD them!) All S&A expenses are variable expenses EXCEPT for the following 2 fixed costs: 1. Rent expense of $15,000 per year in 2020-2022, increasing to $200,000 per year in 2023-2027. 2. Depreciation expense is included in S&A in the amount of 10% of Plant & Equipment each year. INTEREST EXPENSE: This is a Fixed cost, and is 10% of Long-term Liabilities. Guil TAYES. D TAXES: Because you live in a business-friendly State (Wyoming), you don't have to pay state taxes on your LLC's income. You do, however, still have to pay Federal taxes. Also, in 2022, higher tax rates were passed for the 2023 tax year, pushing income over $400,000 into the 39.6% tax bracket. Because of this, use 36% as your effective tax rate. (NOTE: If the taxes shown for 2020-2022 seem high, it's because you had income from another job that threw your LLC income into a slightly higher tax bracket. However, you'll quit that job If the sharks fund you!) SHARES: Issued 72,000 $1-par shares to the sharks for a 48% ownership stake. CASH: Increases to $50,000 in 2023 and stays at that level. MARKETABLE SECURITIES: Plan to keep Marketable Securities at 60% of Cash levels. ACCOUNTS RECEIVABLE: Use a 3-year average Receivables Turnover ratio to forecast. INVENTORY: Compute a 3-year average of inventory as a percent of sales, and then use that figure to forecast inventory levels through 2027. PLANT & EQUIPMENT: New capital expenditure of $750,000 dollars in 2023, paid for with equity funding from the sharks, rather than new debt. All capital expenditures are assumed to occur on January 1st of the year of purchase, and no equipment is sold or salvaged during the forecasted period. ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to the depreciation amount. ACCOUNTS PAYABLE: Use the 3-year average Current Ratio to forecast. ACCRUED EXPENSES: Use the 3-year average Percent of Sales method to forecast. LONG-TERM LIABILITIES: Pay down $100,000 of old debt every year starting in 2023. COMMON STOCK ($1 Par): Increase by the dollar value of shares issued to sharks (26,000 shares at $1 par). CAPITAL PAID IN EXCESS OF PAR: Compute new figure using shark investment, less par value of common stock. RETAINED EARNINGS: Fill in the amount needed to balance the Balance Sheet. DIVIDENDS: You do not pay dividends now and do not plan to while in a growth stage. FIXED & VARIABLE COSTS: The only fixed costs are rent expense, depreciation expense, and interest expense. All other costs are variable. MILESTONE 2 FORECASTED FINANCIALS Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (25 points) Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share 2020 1,200,000 (800,000) 400,000 (304,900) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2022 2021 1,500,000 (1,040,000) 460,000 (350,500) 109,500 (45,000) 64,500 (49,200) 15,300 60,000 $0.26 1,875,000 (1,105,000) 770,000 (443,700) 326,300 (85,000) 241,300 (55,600) 185,700 78,000 $2.38 2023 2024 2025 2026 2027
Expert Answer:
Related Book For
Organizational Behaviour Concepts Controversies Applications
ISBN: 978-0132310314
6th Canadian Edition
Authors: Nancy Langton, Stephen P. Robbins, Timothy A. Judge, Katherine Breward
Posted Date:
Students also viewed these finance questions
-
Your assistant has prepared the following pro forma income statement for 2010. He used your forecast sales figure as the starting point. The administrative expenses are fixed except for salaries,...
-
Using Table 6-13, create a pro forma balance sheet using the percentage of sales method. If net income next year is $50,000, answer the following: a. How much did the owners take out of the business?...
-
Using your pro forma financial statements from The income statement expenses are a constant percentage of revenues except for interest, which remains equal in dollar amount to the 2015 level, and...
-
During the year ended 30 June 2019 XYZ Pty Limited, a resident Australian private company (non BRE), received a franked dividend of $10,800 with $3,200 of attached franking credits. XYZ Pty Limited...
-
How does the accounting for convertible debt under IAS 32 differ from the accounting prescribed by U.S. GAAP?
-
Of those women who are diagnosed to have early-stage breast cancer, one-third eventually die of the disease. Suppose a community public health department instituted a screening program to provide for...
-
Question: The Sisters of Charity was an order of nuns in New Jersey. Faced with growing health care and retirement costs, they decided to sell off a piece of property. The nuns soon found, however,...
-
Sticky Polymers Inc. processes a base chemical into plastic. Standard costs and actual costs for direct materials, direct labor, and factory overhead incurred for the manufacture of 10,750 units of...
-
i need answer On January 1, 2023, Cullumber Corporation purchased a \( \$ 1,140,000 \) bond issued by ALNLtd. The bond was due to matiarn on December 31, 2025, and paid interest at \( 6 \% \) every...
-
Grain is being added to a silo. At time t=0, the silo is empty. The rate at which grain is being added is modeled by the differentiable function g, where g(t) is measured in cubic feet per minute for...
-
The prof gave us this answer but I feel like it's wrong. For the leasehold improvement, why is it 42500/10years? Would it not be 42500/12 years instead because of the renewal? explain Capital Cost...
-
Consider the following Go program allowing the parallel processing of two slices of an array. Here, synchronization is achieved with a WaitGroup. Rewrite the program is performing, this time, a...
-
Consider the pseudo-code of the following sorting algorithm. 1 silly sort (ARRAY): 2 if length (ARRAY) < 2: for (i from 0 to length (ARRAY) - 1): array copy (ARRAY) 3 done 4 else: 5 6 7 8 9 10 11 12...
-
Roy Photography Supply, Inc., purchased inventory for $2,300 and paid $175 freight to have the inventory delivered. Roy Photography Supply, Inc., returned $100 of the goods to the seller and later...
-
You just viewed a scene from the film "Dances with Wolves" starring Kevin Costner. The year is 1868 and Kevin Costner's character, Lieutenant John Dunbar, is posted at an army base in the western...
-
SE Bhd manufactures two types of hair dryer. Silent design hair dryer sells for RM100.00 and the standard design hair dryer that sells for RM70.00 per unit. In 2022, the company estimates to incur...
-
Power companies are presented with a number of opportunities as well as challenges as a result of the growth of customer-produced electricity, particularly power supplied by renewable sources such as...
-
Refer to the situation described inBE 18-13, but assume a 2-for-1 stock split instead of the 5% stock dividend. Prepare the journal entry to record the stock split if it is to be effected in the form...
-
If you were an employee in a matrix structure, what pluses do you think the structure would provide? What about minuses?
-
Why do you think the subject of OB might be criticized as being only common sense, when one would rarely hear such a criticism of a course in physics or statistics? Do you think this criticism of OB...
-
How does Lewins three-step model of change deal with resistance to change?
-
Consider the following three-player game in strategic form. Each player has two strategies: Player I has the strategies \(T\) and \(B\) (the top and bottom row), player II has the strategies \(l\)...
-
Consider the following \(3 \times 3\) game. (a) Identify all pairs of strategies where one strategy weakly dominates the other. (b) Assume you are allowed to remove a weakly dominated strategy of...
-
Consider the following game tree. As always, the top payoffs at a leaf are for player I and bottom payoffs for player II. (a) What is the number of strategies of player I and of player II? (b) How...
Study smarter with the SolutionInn App