Concept explainers
Stevens Textile Corporation’s 2019 financial statements are shown here. Stevens grew rapidly in 2019 and financed the growth with notes payable and long-term bonds. Stevens expects sales to grow by 15% in the next year but will finance the growth with a line of credit, not notes payable or long-term bonds. Use the
- a. What is the projected value for earnings before interest and taxes?
- b. What is the projected value for pre-tax earnings?
- c. What is the projected net income?
- d. What is the projected addition to retained earnings?
- e. What is the projected value of total current assets?
- f. What is the projected value of total assets?
- g. What is the projected sum of accounts payable, accruals, and notes payable?
- h. What is the forecasted line of credit?
Balance Sheet as of December 31, 2019 (Thousands of Dollars)
Income Statement for December 31, 2019 (Thousands of Dollars)
Trending nowThis is a popular solution!
Chapter 12 Solutions
Financial Management: Theory & Practice
- Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $6 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%, and the forecasted retention ratio is 25%. Use the AFN equation to forecast Carlsbad's additional funds needed for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollaarrow_forwardCarlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%, and the forecasted retention ratio is 35%. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar. i keeo getting it wrong, i got: can you help me walk though it with excel formulas please :) ASSETS $ 4,000,000.00 SALES IN 2019 $ 5,000,000.00 TOTAL LIBS $ 1,000,000.00 SALES IN 2020 $ 6,000,000.00 AP $ 250,000.00 VALUE OF SALES INCEASE $…arrow_forwardCarlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $3 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 6%. a. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar. b. Why is this AFN different from the one when the company pays dividends? I. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed. II. Under this scenario the company would have a higher…arrow_forward
- Kestus Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $5 million at the end of 2019. Kestus is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 6%, and the forecasted retention ratio is 25%. Use the AFN equation to forecast Kestus additional funds needed for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar. Now assume the company's assets totaled $3 million at the end of 2019. Is the company's "capital intensity" the same or different comparing to initial situation?arrow_forwardCarston Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carston is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%, and the forecasted retention ratio is 40%. Use the AFN equation to forecast the additional funds Carston will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.arrow_forwardBeasley Industries' sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $2 million at the end of 2019. Beasley is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $700,000, consisting of $120,000 of accounts payable, $350,000 of notes payable, and $230,000 of accrued liabilities. Its profit margin is forecasted to be 4%, and its dividend payout ratio is 50%. Using the AFN equation, forecast the additional funds Beasley will need for the coming year. Do not round intermediate calculations. Round your answer to the nearest dollar.arrow_forward
- Carlsbad Corporation’s sales are expected to increase from $5 millionin 2018 to $6 million in 2019, or by 20%. Its assets totaled $3 million at the end of 2018.Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At theend of 2018, current liabilities are $1 million, consisting of $250,000 of accounts payable,$500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecastedto be 3%, and the forecasted retention ratio is 30%. Use the AFN equation to forecast theadditional funds Carlsbad will need for the coming year.arrow_forwardA group of investors is planning to set up a new company. To help determine the new company’s financial requirements, the president has asked you to construct a pro forma balance sheet for 31 December 2019, the end of the first year of operations, and to estimate the company’s external financing requirements for 2019. Sales for 2019 are projected at $25 million, and the following are industry average ratios for similar companies: Sales to common equity (S/E) 5 times Current debt to equity (CL/E) 50% Total debt to equity (D/E) 80% Current ratio (CA/CL) 2.2 times Sales to inventory (S/Inv) 9 times Accounts receivable to sales ((A/R)/S) 10% Fixed assets to equity (FA/E) 70% Profit margin (NIAT/S) 5% Dividend payout ratio (DIV/NIAT) 30% a. Complete the pro forma balance sheet below, assuming that 2019 sales are $25 million and that the firm maintains industry average ratios b. What would be the amount of equity financing that must be supplied by the investors?arrow_forwardBulawayo Products Company anticipates reaching a sales level of Sh.6 million in one year.The company expects earnings after taxes during the next year to equal Sh.400,000. During thepast several years, the company has been paying Sh.50,000 in dividends to its stockholders. Thecompany expects to continue this policy for at least the next year. The actual balance sheet andincome statement for Baldwin during 2019 follow.Bulawayo Products Company Balance Sheet as of December 31, 2019Cash Sh. 200,000 Accounts payable Sh. 600,000Accounts receivable 400,000 Notes payable 500,000Inventories 1,200,000 Long-term debt 200,000Fixed assets, net 500,000 Stockholders’ equity 1,000,000Total assets Sh.2,300,000 Total liabilities and equity Sh. 2,300,000Income Statement for the year Ending December 31, 2019Sales Sh. 4,000,000Expenses, including interest and taxes Sh.3,700,000Earnings after taxes Sh. 300,000Required:a) Using the percentage of sales method, calculate the additional financing…arrow_forward
- Broussard Skateboard's sales are expected to increase by 25% from $7.2 million in 2019 to $9.00 million in 2020. Its assets totaled $5 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450000 of accounts payable, $500000 of notes payable, and $450000 of accruals. The after-tax profit margin is forecasted to be 3%, and the forecasted payout ratio is 55%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar.arrow_forwardCoronado Industries has recently reported steadily increasing income. The company reported income of €20,400 in 2019, €25,500 in 2020, and €30,600 in 2021. A number of market analysts have recommended that investors buy Coronado shares because the analysts expect the steady growth in income to continue. Coronado is approaching the end of its fiscal year in 2022, and it again appears to be a good year. However, it has not yet recorded warranty expense. Based on prior experience, the 2022 warranty expense should be around €5,100, but some managers have approached the controller to suggest a larger, more conservative warranty expense should be recorded this year. Income before warranty expense is €43,200. Specifically, by recording a €6,700 warranty accrual this year, Coronado could report an increase in income for this year and still be in a position to cover its warranty costs in future years. (c) Assume income before warranty expense is €43,200 for both 2022 and 2023 and that total…arrow_forwardAssume the company uses the AFN formula and all additional funds needed (AFN) will come from issuing new long-term debt. Given its forecast, how much long-term debt will the company have to issue in 2023? Lux Co. has the following balance sheet as of December 31, 2022arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning