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 "What is the estimate for Net New Financing for 2023? Note: Make sure you use the correct positive or negative sign. 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 "What is the estimate for Net New Financing for 2023? Note: Make sure you use the correct positive or negative sign. 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)
To estimate the Net New Financing for 2023 we need to determine the financing needed to support the ... View the full answer
Related Book For
Cost Management Accounting and Control
ISBN: 978-0324559675
6th Edition
Authors: Don R. Hansen, Maryanne M. Mowen, Liming Guan
Posted Date:
Students also viewed these finance questions
-
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...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Make a presentation about marketing: Your Companys marketing department promotes the products and interacts with the customers, sales force, and supply chain. They are also in charge of forecasting...
-
In Figure R 1 = 20.0?, R 2 = 10.0?, and the ideal battery has emf ? = 120V.What is the current at point a if we close (a) Only switch S 1 , (b) Only switches S 1 and S 2 , and (c) All three switches?...
-
Isothermal efficiency is defined as the ratio of the (a) Isothermal work to the actual work, i.e., \(\eta_{\text {iso }}=\frac{W_{\text {iso }}}{W_{\text {actual }}}\) (b) Actual work to the...
-
On August 31, Pro Tennis Equipment had a $150,000 debit balance in Accounts Receivable. During September, Pro Tennis Equipment had the following transactions: Sales of $500,000, all on credit. ...
-
Peterman Co. was organized on July 1, 2012. Quarterly financial statements are prepared. The unadjusted and adjusted trial balances as of September 30 are shown below. Instructions (a) Journalize the...
-
Pintime Industries Incorporated entered into a business combination agreement with Sydrolized Chemical Corporation (SCC) to ensure an uninterrupted supply of key raw materials and to realize certain...
-
A chain coffee shop company is considering adding a new line of business of offering small foods and snacks. The CEO of the company hired you as a financial analyst to help the company decide if it...
-
How many processes are created in the following program Explain the following Difference between short-term and long-term scheduling Ordinarily the exec() system call follows the fork(). Explain what...
-
Given the matrices in Problems 16-19, perform elementary row operations to obtain a 1 in the row 1, column 1 position. \([D]=\left[\begin{array}{rrr:r}5 & 20 & 15 & 6 \\ 7 & -5 & 3 & 2 \\ 12 & 0 & 1...
-
Table 18.3 gives some distances and commute times for a typical daily commute. Find the average speed (to the nearest mph) for the time intervals requested in Problems 1-4. Table 18. 3 \(6: 36\) to...
-
Consider the following apportionment problem: If there are to be 475 representatives, use the apportionment plan requested in Problems 56-60. HH's plan North: Northeast: East: Southeast: South:...
-
Given the matrices in Problems 24-27, perform elementary row operations to obtain a 1 in the second row, second column without changing the entries in the first column....
-
What is a mathematical model? Why are mathematical models necessary or useful?
-
A company produces a product for sale at $24 per unit. Costs are $48,000 per month for total fixed costs and $16 for variable costs per unit. The number of units to be produced and sold per month to...
-
Which, if any, of the dichloroethene molecules drawn in Data Table II (3.) (4.) and (5.) are geometric isomers? A. B. C. D. cis-1,2-dichloroethene and trans-1,2-dichloroethene...
-
Classify the following environmental activities as prevention costs, detection costs, internal failure costs, or external failure costs. For external failure costs, classify the costs as societal or...
-
What are the four stages of the consumption life cycle? What are post-purchase costs? Explain why a producer may want to know post-purchase costs.
-
Azari, Inc. has just created five order fulfillment value streams, two focused and three that produce multiple products. The size of the plant in which the values streams are located is 150,000...
-
Assign account numbers (from the list that follows) to the accounts of Clarke Logistics. Jan Marks, Withdrawals Service Revenue Depreciation Expense Numbers from which to choose: Inventory Accounts...
-
The spreadsheet screen in Exhibit 7-5, is your income statement. Suppose you are developing your financial plan for the coming year. Revenues should increase by \(8 \%\) and expenses by \(6 \%\)....
-
The individual accounts in the accounts receivable subsidiary ledger identify a. Customers b. Creditors c. Amounts to be paid d. Suppliers
Study smarter with the SolutionInn App