Data from Epo's 2021 Income statement & balance sheet and 2022 sales forecast are below. Actual...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data from Epo's 2021 Income statement & balance sheet and 2022 sales forecast are below. Actual Fiscal Year: 2021 Forecast: 2022 SalesTo $3,500,000 Sales growth rate 45.0% Costs $2.050.000 Taxable income $1,450,000 Taxes $362,500 Net income $1,087,500 Dividends $163.125 Addition to RE $924,375 CL & Equity: Assets: Actual Fiscal Year: 2021 Forecast 2022 Actual Fiscal Year: 2021 Forecast 2022 Cash S110.000 Acts Payable $265,950 Acts Receivable 390,000 Accruals 273,817 Inventories 365,000 Notes payable 100.000 Net Fixed Assets 1,520.000 LT Debt 521,500 Common Stock 175,300 Retained Earnings Total Liab & Equity 1.048.433 Total Assets $2,385.000 $2,385,000 Epo's fixed assets are at 100% capacity and current asset relationships to sales reflect desired levels for operations. Epo expects to reduce its costs by 10% next year and will face a 30% tax rate. Epo's bank has told them they will not increase the current line of credit. Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? #1 EFN = $ #2 Estimate the sustainable growth rate. #3 What would the impact on EFN be supply chain issues increased costs by 20%? Answer in words and with supporting numbers. Data from Epo's 2021 Income statement & balance sheet and 2022 sales forecast are below. Actual Fiscal Year: 2021 Forecast: 2022 SalesTo $3,500,000 Sales growth rate 45.0% Costs $2.050.000 Taxable income $1,450,000 Taxes $362,500 Net income $1,087,500 Dividends $163.125 Addition to RE $924,375 CL & Equity: Assets: Actual Fiscal Year: 2021 Forecast 2022 Actual Fiscal Year: 2021 Forecast 2022 Cash S110.000 Acts Payable $265,950 Acts Receivable 390,000 Accruals 273,817 Inventories 365,000 Notes payable 100.000 Net Fixed Assets 1,520.000 LT Debt 521,500 Common Stock 175,300 Retained Earnings Total Liab & Equity 1.048.433 Total Assets $2,385.000 $2,385,000 Epo's fixed assets are at 100% capacity and current asset relationships to sales reflect desired levels for operations. Epo expects to reduce its costs by 10% next year and will face a 30% tax rate. Epo's bank has told them they will not increase the current line of credit. Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? #1 EFN = $ #2 Estimate the sustainable growth rate. #3 What would the impact on EFN be supply chain issues increased costs by 20%? Answer in words and with supporting numbers.
Expert Answer:
Answer rating: 100% (QA)
Sales Base sales 145 Cost base cost 145110 taxable inc sales cost Tax 30 o... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0324312140
16th Edition
Authors: James D. Stice, Earl K. Stice, Fred Skousen
Posted Date:
Students also viewed these finance questions
-
Current Assets 2000 2001 Cash 200 1 000 Accounts receivable 1 600 1 000 Inventory 2 200 2 600 TOTAL CURRENT ASSETS 4 000 4 600 Gross Fixed Assets 12 000 12 400 Less Accum Depreciation 6 000
-
Below are balance sheet and income statement data for Blue Panel Corporation. Additional information for Blue Panel Corporation is as follows: (a) Property, plant, and equipment with an original...
-
Below are balance sheet and income statement data for Judy Maxwell Company. Additional information for Judy Maxwell Company is as follows: (a) Property, plant, and equipment with an original...
-
Joel purchased 100 shares of stock for $20 per share. During the year, he received dividend cheques amounting to $150. After three years, Joel sold the stock for $32 per share. What was his holding...
-
Tony began a small retailing operation on January 1, 2015. During 2015, the following transactions occurred: 1. Tony contributed $20,000 of his own money to the business. 2. $60,000 was borrowed from...
-
Refer to the preceding facts for Packards acquisition of Stude common stock. On January 1, 2012, Packard held merchandise acquired from Stude for $10,000. This beginning inventory had an applicable...
-
Indicate whether each of the following costs related to inventory, a through I, would be considered (1) a purchasing cost, (2) an ordering cost, (3) a carrying cost, or (4) a cost of not carrying...
-
Steamboat Co. expects to maintain the same inventories at the end of 2010 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost...
-
---------- is conducted against information and information-processing equipment used by an adversary
-
"Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing...
-
In a recent study on world happiness, participants were asked to evaluate their current lives on a scale from 0 to 10, where 0 represents the worst possible life and 10 represents the best possible...
-
Based on the text reading and other materials used, explain when a manager would use cost-volume-profit analysis and sensitivity analysis. In addition to the discussion, suppose a company decided to...
-
What is working Capital ? Explain Types of Working Capital Explain Needs of Working Capital Explain short term and Long Term sources of working capital financing Compare working capital Practices in...
-
A recycling center sees 40 people drop off items each hour they are open. Assuming constant probability and independence, find the probability 15 people drop off items in 30 minutes. Round off your...
-
PopUp Company produces two types of toasters, basic and deluxe. For the current period, the company reports the following data: Basic Toaster Deluxe Toaster Volume 20,000 units 5,000 units Machine...
-
Ms. Zelda has decided to invest $75,000 in state bonds. She could invest in State A bonds paying 5 percent annual interest or in State R bonds paying 5.4 percent annual interest. The bonds have the...
-
For the Morrison Company Case Study in its entirety, what would be the short-term and long-term strategic supply chain and operating strategy recommendations to be offered as tactical solutions (for...
-
Determine the optimal use of Applichem's plant capacity using the Solver in Excel.
-
To help you become familiar with the accounting standards, this case is designed to take you to the FASBs Web site and have you access various publications. Access the FASBs Web site at www.fasb.org....
-
During Year 1, Rosie Company purchased 8,000 shares of Company A common stock for $30 per share and 5,000 shares of Company B common stock for $50 per share. These investments are classified as...
-
Rowberry Company computed a pretax financial loss of $5,000 for the first year of its operations ended December 31, 2008. Included in the loss was $28,000 in uncollectible accounts expense that was...
-
For each of the following unrelated columns of data for the year, compute the cost of goods manufactured and the cost of goods sold: A B C Selling expenses Factory insurance. Ending finished goods...
-
Brooklyn Company reported the following amounts for October: Use Excel to prepare a schedule of cost of goods sold for October. Beginning raw materials inventory. Beginning work-in-process inventory...
-
Kelly Metal Products Corporation sold 18,000 units of product for \($40\) each during 2019. During the year, 10,000 shares of common stock were outstanding. Prepare an income statement for the year...
The Pfeiffer Book Of Successful Conflict Management Tools 1st Edition - ISBN: 0470193441 - Free Book
Study smarter with the SolutionInn App