A 1 2 Industry Sales Scenario 3 Optimistic forecast 4 Management forecast 5 Pessimistic forecast 6...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A 1 2 Industry Sales Scenario 3 Optimistic forecast 4 Management forecast 5 Pessimistic forecast 6 Average sales growth rate 7 8 9 10 11 Income Statements 12 13 Sales 14 Costo of Goods Sold 15 Gross Profit 16 17 Marketing Expenses 18 Maintainance Expense 19 Depreciation 20 EBIT 21 Less interest 22 Earning before taxes (EBT) 23 Less taxes (40%) 24 Net income 25 Less cash distributions 26 Added retained earnings 27 28 29 30 Balance Sheets 31 32 Cash 33 Accounts Rec 34 Inventories 35 Total Current Assets 36 Fixed Assets, Net 37 Total Assets 38 39 Accounts Pay 40 Aco Liabilities 41 Bank Loan 42 Total Current Liab 43 Common Equity 44 Long-Term Debt 45 Additional Funds Needed 46 Total Liabilities and equity 47 Probability of Sales ocurrence growth rate 60% 35% 10% 0.2 0.4 OO 44 0.4 Percent 2023 of Sales 0.00% $ 48,400 0 48,400 -20,000 -16,000 0 12,400 589 11,811 4.724 7,087 0 2023 C 48,400 0 48,400 80.000 $ 128,400 80.000 80,000 48,400 4100% 20.00% 100.00% D E Components to sum 12.00% Forecast Basis Costo fijo $128.400 48 AFN is a plug amount that makes the total assets balance with the total liabilities and equity 49 (Note Forecasts are prior to ang new interest-bearing debt or equity financing 1 50 Mi empresa Sheet2 14.00% 4.00% 10.00% Forecast Basis Sheet3 7 $ 1 2024 $ 60,500 $ 60,500 (24,805) -16,000 19,695 936 18,759 7.504 11,256 0 2024 60,500 60,500 80.000 80,000 60,500 $ 140.500 1 2025 75,625 75,625 (31,006) -16,000 28,619 1359 27,259 27,259 0 27,259 2025 80.000 80.000 140.500 $ 155.625 75,625 75,625 80.000 80.000 75.625 155.625 complete the cash statement A Statement of Cash Flows Net Income Depreciation (plus) Increase in Accounts receivable (less) 7 Increase in Inventories (less) 8 Increase in Accounts payable (plus) 59 Increase in Accrued Liabilities (plus) 50 Cash Flow from Operations 61 62 Change in Fixed Assets, Net 63 Cash Flow from Investments 64 65 Change in Bank Loan 66 Change in Long-Term Debt: 67 Change in Common Stock 68 Payment of Cash Dividends 69 Cash Flow from Financing 70 71 Net Cash Flow 72 Beginning Cash 73 Ending Cash Before Borrowing 74 75 B с D E 2024 G 2025 A 1 2 Industry Sales Scenario 3 Optimistic forecast 4 Management forecast 5 Pessimistic forecast 6 Average sales growth rate 7 8 9 10 11 Income Statements 12 13 Sales 14 Costo of Goods Sold 15 Gross Profit 16 17 Marketing Expenses 18 Maintainance Expense 19 Depreciation 20 EBIT 21 Less interest 22 Earning before taxes (EBT) 23 Less taxes (40%) 24 Net income 25 Less cash distributions 26 Added retained earnings 27 28 29 30 Balance Sheets 31 32 Cash 33 Accounts Rec 34 Inventories 35 Total Current Assets 36 Fixed Assets, Net 37 Total Assets 38 39 Accounts Pay 40 Aco Liabilities 41 Bank Loan 42 Total Current Liab 43 Common Equity 44 Long-Term Debt 45 Additional Funds Needed 46 Total Liabilities and equity 47 Probability of Sales ocurrence growth rate 60% 35% 10% 0.2 0.4 OO 44 0.4 Percent 2023 of Sales 0.00% $ 48,400 0 48,400 -20,000 -16,000 0 12,400 589 11,811 4.724 7,087 0 2023 C 48,400 0 48,400 80.000 $ 128,400 80.000 80,000 48,400 4100% 20.00% 100.00% D E Components to sum 12.00% Forecast Basis Costo fijo $128.400 48 AFN is a plug amount that makes the total assets balance with the total liabilities and equity 49 (Note Forecasts are prior to ang new interest-bearing debt or equity financing 1 50 Mi empresa Sheet2 14.00% 4.00% 10.00% Forecast Basis Sheet3 7 $ 1 2024 $ 60,500 $ 60,500 (24,805) -16,000 19,695 936 18,759 7.504 11,256 0 2024 60,500 60,500 80.000 80,000 60,500 $ 140.500 1 2025 75,625 75,625 (31,006) -16,000 28,619 1359 27,259 27,259 0 27,259 2025 80.000 80.000 140.500 $ 155.625 75,625 75,625 80.000 80.000 75.625 155.625 complete the cash statement A Statement of Cash Flows Net Income Depreciation (plus) Increase in Accounts receivable (less) 7 Increase in Inventories (less) 8 Increase in Accounts payable (plus) 59 Increase in Accrued Liabilities (plus) 50 Cash Flow from Operations 61 62 Change in Fixed Assets, Net 63 Cash Flow from Investments 64 65 Change in Bank Loan 66 Change in Long-Term Debt: 67 Change in Common Stock 68 Payment of Cash Dividends 69 Cash Flow from Financing 70 71 Net Cash Flow 72 Beginning Cash 73 Ending Cash Before Borrowing 74 75 B с D E 2024 G 2025
Expert Answer:
Answer rating: 100% (QA)
Financial Projections Assumptions Industry sales growth rate 4 Company sales growth rate 10 Cost of ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 4am-6am 6am - 8am 8am -10am 10am-12pm 12pm-2pm 2pm-4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Monday 2022 Daily Attendance Trends 50 125 100 90 75 62 125 125 75 Balance S...
-
Acculturation is an extremely important topic in this age of globalization and multiculturalism; however, it remains an especially difficult topic to study. Peoples acculturation experiences vary...
-
Lenses with given radii. Object O stands in front of a thin lens, on the central axis. For this situation, each problem in Table 34-7 gives object distance p, index of refraction n of the lens,...
-
Consider the two-component assembly shown in Figure 9-15. Suppose that the specifications for the dimension X2 are 5 0.05 cm and those for X1 are 12 0.15 cm. Find the specifications for the...
-
Benjamin and Mia both work at the Grease Fire diner, a local eatery. Benjamin has every 4th day off, and Mia has every 6th day off. How many days pass until they have another day off together?
-
Multiple Choice. Choose the best answer. 1. Which of the following correctly states the role of budgeting in proprietary funds? a. Proprietary fund managers should ensure that a valid appropriation...
-
or course finance merger and acquisitions 4.1 How does planning facilitate the acquisition process? 4.3 What are the advantages and disadvantages of using an acquisition to implement a business str...
-
Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Assembly....
-
On average, a firm sells $2,500,000 in goods per month. Cost of goods sold equals 60 percent of sales and always keeps inventory on hand equal to half the monthly cost of goods. If the firm analyzes...
-
Discuss what performance management is and how it influences effective teams.
-
A certain drug is eliminated from the bloodstream with a half-life of 34 hours. Suppose that a patient receives an initial dose of 75mg of the drug at midnight. a. How much of the drug is in the...
-
Steve Pratt, who is single, purchased a home in Riverside, California, for $ 4 0 0 , 0 0 0 . He moved into the home on February 1 of year 1 . He lived in the home as his primary residence until June...
-
Critically analyze the historical transition of East German Democratic State from Authoritarianism to Democracy. Highlight the challenges and achievement with references
-
create a unit test to test the total calory calculation , to use classes and to do a proper error handling and data validation . The user shall be able to enter an unlimited number of recipes . The...
-
What is a sampling frame and why is it needed in probability sampling. Explain how it is part of the process of random selection of a sample.
-
In your readings, there were many examples given for nurturing close family relationships in this ever-evolving technological society we live in Based upon your readings and research describe three...
-
Researchers have noted that pathological gambling and obsessive-compulsive disorder (OCD) share some similarities such as being unable to delay or withhold repetitive behaviors. Accordingly, Durdle,...
-
The variance of the parent population is equal to 5 and the standard deviation is 5 2.2361. a. Calculate the standard error of the mean for the problem presented in Exercise 1. b. What is the symbol...
-
Find the critical values for the following F tests: 1. = .01, df between = 2, df within = 50 2. = .01, df between = 2, df within = 200 3. = .05, df between = 3, df within = 70 4. = .05, df...
-
In the discussion at the beginning of this chapter, do you think the motivations for holding cash are reasonable?
-
Solicitous Bank offers your firm an 8 percent discount interest loan for up to \($3\) million, and in addition requires you to maintain a 6 percent compensating balance against the amount borrowed....
-
Formulate complete PDE problems (specify the equation, space domain, time interval, and boundary and initial conditions) for the following model situations. a) Conduction heat transfer occurs in a...
Study smarter with the SolutionInn App