Use Table 1 and the following information on Company X to perform a pro-forma financial modeling...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
"Use Table 1 and the following information on Company X to perform a pro-forma financial modeling using a percentage sales method, and answers the next questions. Note: When applying the percentage sales method, you should assume that the 2023 percentage values with respect to sales of the (i) costs except depreciation, (ii) depreciation, (iii) cash and equivalents, (iv) accounts receivable, (v) inventories, (vi) property, plant and equipment, and (vi) accounts payable will remain equal to those percentages of 2022. Sales in 2023 are expected to grow at a rate of 10%, with respect to the values of 2022. Assume also that the total values in 2023 of interest expense and debt will not change from its 2022 values; income tax will remain at 3% of the Pretax Income; and that Company X initially plans to payout 35% of its net income to its shareholders. ****Insert TABLE 1 here What is the forecasted value of sales for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000." Table 1 Income Statement, 2022 Sales Costs except Depr. EBITDA Depreciation EBIT Interest Expense (net) Pretax Income Income Tax Net Income 800,000 -650,000 150,000 -2,000 148,000 -100,500 47,500 -1,425 46,075 Balance Sheet, 2022 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property Plant & Equipment Total Assets Liabilities & Equity Accounts Payable Debt Total Liabilities Stockholders' Equity Total Liabilities and Equity 250,000 90,000 20,000 360,000 200,000 560,000 200,000 100,000 300,000 260,000 560,000 QUESTION 7 "Before making additional balancing adjustments to the Balance Sheet, what is the forecasted value of Total Liabilities for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000." QUESTION 8 "Before making additional balancing adjustments to the Balance Sheet, what is the forecasted value of Shareholder's Equity for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000." "Use Table 1 and the following information on Company X to perform a pro-forma financial modeling using a percentage sales method, and answers the next questions. Note: When applying the percentage sales method, you should assume that the 2023 percentage values with respect to sales of the (i) costs except depreciation, (ii) depreciation, (iii) cash and equivalents, (iv) accounts receivable, (v) inventories, (vi) property, plant and equipment, and (vi) accounts payable will remain equal to those percentages of 2022. Sales in 2023 are expected to grow at a rate of 10%, with respect to the values of 2022. Assume also that the total values in 2023 of interest expense and debt will not change from its 2022 values; income tax will remain at 3% of the Pretax Income; and that Company X initially plans to payout 35% of its net income to its shareholders. ****Insert TABLE 1 here What is the forecasted value of sales for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000." Table 1 Income Statement, 2022 Sales Costs except Depr. EBITDA Depreciation EBIT Interest Expense (net) Pretax Income Income Tax Net Income 800,000 -650,000 150,000 -2,000 148,000 -100,500 47,500 -1,425 46,075 Balance Sheet, 2022 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property Plant & Equipment Total Assets Liabilities & Equity Accounts Payable Debt Total Liabilities Stockholders' Equity Total Liabilities and Equity 250,000 90,000 20,000 360,000 200,000 560,000 200,000 100,000 300,000 260,000 560,000 QUESTION 7 "Before making additional balancing adjustments to the Balance Sheet, what is the forecasted value of Total Liabilities for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000." QUESTION 8 "Before making additional balancing adjustments to the Balance Sheet, what is the forecasted value of Shareholder's Equity for 2023? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."
Expert Answer:
Answer rating: 100% (QA)
Lets start with calculating the forecasted value of sales for 2023 Forecasted Sales for 2023 Sales in 2022 1 Growth Rate Forecasted Sales for 2023 800... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Boeing outsourced their 787 "Dreamliner," butthe outsourcing decision ricocheted, resultingincosts over budget, rescinded sales, customers seekingcompensation for delays, and reduced potential ROI....
-
2. The figure below illustrates a mass that is connected to a movable base via a spring and a damper. The positions of the mass and base are defined by x and xb, respectively. Assume that the mass...
-
Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion method to answers question (3) and (4). To do this assume that the percentage values with...
-
You kick a soccer ball, compressing it suddenly to 2/3 of its original volume. In the process, you do 410 J of work on the air (assumed to be an ideal gas) inside the ball. (a) What is the change in...
-
The current drawn from a battery is 1.80 A when a 7.0- resistor is connected across the battery terminals. If a second 12- resistor is connected in parallel with the 7- resistor, the battery delivers...
-
Arethe Chief Compliance Officer of a Fortune 500 company. Through a routine compliance audit, you have discovered potential illegal activity within one of the corporate divisions. Youhave advised the...
-
When two bodies are in thermal equilibrium (a) They have the same pressure (b) They have the same temperature (c) They are in a quasi-static state of equilibrium (d) They have the same chemical...
-
If you anticipate that the price of a stock will rise, you could (1) buy the stock, (2) buy a call, (3) sell a covered call, or (4) sell a put. All four positions may generate profits if the price of...
-
John Smith and Mary Jones are in a partnership which provides consulting services in the bio - tech industry. John and Mary share profits and losses on a 2 : 3 ratio. On December 3 1 , 2 0 2 3 , they...
-
What is the best way for Matt to avold plagiarism If a few staff members of LELO have provided Matt with their speeches and reports to use In his work, but the source section is missing in one?
-
In his book, The Post-Industrial Society, Peter Drucker wrote: Society, community, and family are all conserving institutions. They try to maintain stability and to prevent, or at least slow down,...
-
(a) One of the main problems encountered in the design of a diesel engine combustion system is the mixing of the air and fuel sufficiently rapidly to ensure complete combustion. Explain, using...
-
An electric cell is based on the reaction \(\mathrm{Pb}+\mathrm{Hg}_{2} \mathrm{Cl}_{2} ightarrow \mathrm{PbCl}_{2}+2 \mathrm{Hg}\). If the enthalpy of reaction for this reaction, \(Q_{p}\), at...
-
Calculate the emf of a hydrogen-oxygen fuel cell operating reversibly if the overall reduction in Gibbs energy is \(238 \mathrm{MJ} / \mathrm{kg} \mathrm{H}_{2}\). If the cell operates at \(75 \%\)...
-
The exhaust gases of a compression-ignition engine are to be used to drive an exhaust gas turbo-supercharger. Estimate the mean pressure ratio of expansion and the isentropic enthalpy drop per kmol...
-
$ Gross pay for an employee who earns $13/hour, is paid overtime wages at 1.5 times their regular pay rate, and worked 42 hours this week is
-
The following information is available for Partin Company: Sales $598,000 Sales Returns and Allowances 20,000 Cost of Goods Sold 398,000 Selling Expense 69,000 Administrative Expense 25,000 Interest...
-
The first decade of the 21st century witnessed a flurry of losses, bankruptcies, acquisitions, and strategic partnerships in the airline industry. The heavily levered firms in the industry are...
-
Firm A reports an increase in earnings per share; Firm B reports a decrease in earnings per share. Is this unconditionally informative about each firms performance? If not why is earnings per share...
-
Sunbeam Corporation manufactures and sells a variety of small household appliances, including toasters, food processors, and waffle grills. Exhibit 3.26 presents a statement of cash flows for Sunbeam...
-
Does statelessness exist in wealthy countries such as the United States? How does the status of the "Dreamers" (people who entered the United States illegally as young children) compare with that of...
-
How does political organization relate to social differentiation?
-
What are stratified societies and what kinds of social systems are they identified with?
Study smarter with the SolutionInn App