Fundamentals of Corp. Fin. (Looseleaf)(Custom)
15th Edition
ISBN: 9781269945646
Author: Berk
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 20, Problem 1CQ
Based on the
1 | Year | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
2 | Income Statement ($000s) | ||||||
3 | Sales | 100,000 | |||||
4 | Cost of Goods Sold | -45,333 | |||||
5 | Gross Profit | 54,667 | |||||
6 | Sales and Marketing | -15,000 | |||||
7 | Administration | -18,000 | |||||
8 | EBITDA | 21,667 | |||||
9 | -6,667 | ||||||
10 | EBIT | 15,000 | |||||
11 | Interest Expense (net) | -1,021 | |||||
12 | Pretax Income | 13,979 | |||||
13 | Income Tax | -4,893 | |||||
14 | Net Income | 9,086 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The Optical scam company has forecast a sales growth of 20 percent for next year. The current financial statements are shown below:
What is pro forma balance sheet for next year?
Sales
$ 31,600,000
Costs
26,675,500
Taxable income
$ 4,924,500
Taxes
1,723,575
Net income
$ 3,200,925
Dividends
$ 1,280,370
Addition to retained earnings
1,920,555
Balance Sheet
Assets
Liabilities and Owners' Equity
Current assets
$ 7,320,000
Accounts payable
$ 5,688,000
Long-term debt
6,636,000
Fixed assets
20,172,000
Common stock
$ 1,594,000
Accumulated retained earnings
13,574,000
Total equity
$ 15,168,000
Total assets
$ 27,492,000
Total liabilities and equity
Using the AFN formula in financial forecasting approach, Determine the following for Piano Co. given the following accounting information assuming that the firm’s profit margin remains constant and the company is at full capacity. · Sales this year is P6,000,000· Percentage increase projected for next year sales = 20%· Net income this year amounts to P600,000· Retention ratio = 50%· Accounts payable = P1,100,000· Notes payable = P180,000· Accrued expenses = P500,000· Projected excess funds available next year is determined to be P200,000
Questions:
1. Determine the spontaneous liabilities increase.
2. How much is the increase in Retained Earnings?
3. How much is the total assets?
Chapter 20 Solutions
Fundamentals of Corp. Fin. (Looseleaf)(Custom)
Ch. 20 - Prob. 1CCCh. 20 - 2. What is the effect of seasonalities on...Ch. 20 - Prob. 3CCCh. 20 - Prob. 4CCCh. 20 - Prob. 5CCCh. 20 - Prob. 6CCCh. 20 - Prob. 7CCCh. 20 - Prob. 8CCCh. 20 - Prob. 9CCCh. 20 - Prob. 10CC
Ch. 20 - Based on the forecasts in this case, use the...Ch. 20 - Use the following spreadsheet to project Idexo’s...Ch. 20 - Based on the forecasts you have already developed,...Ch. 20 - Prob. 4CQCh. 20 - Prob. 5CQCh. 20 - Prob. 1CTCh. 20 - Prob. 2CTCh. 20 - Which of the following companies are likely to...Ch. 20 - Prob. 4CTCh. 20 - Prob. 5CTCh. 20 - Prob. 6CTCh. 20 - Prob. 7CTCh. 20 - What is the difference between evergreen credit...Ch. 20 - Prob. 9CTCh. 20 - Prob. 10CTCh. 20 - Prob. 11CTCh. 20 - Prob. 1PCh. 20 - Prob. 2PCh. 20 - Prob. 3PCh. 20 - The following table includes quarterly working...Ch. 20 - Prob. 5PCh. 20 - Prob. 6PCh. 20 - Prob. 7PCh. 20 - Hand-to-Mouth (H2M) is currently cash-constrained,...Ch. 20 - Prob. 9PCh. 20 - Prob. 10PCh. 20 - Prob. 11PCh. 20 - Prob. 12PCh. 20 - Prob. 13PCh. 20 - Prob. 14PCh. 20 - Prob. 15PCh. 20 - Prob. 16PCh. 20 - The Rasputin Brewery is considering using a public...Ch. 20 - Prob. 18P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forwardForecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Uptons balance sheet as of December 31, 2018, is shown here (millions of dollars): Sales for 2018 were 350 million, and net income for the year was 10.5 million, so the firms profit margin was 3.0%. Upton paid dividends of 4.2 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2019. a. If sales are projected to increase by 70 million, or 20%, during 2019, use the AFN equation to determine Uptons projected external capital requirements. b. Using the AFN equation, determine Uptons self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? c. Use the forecasted financial statement method to forecast Uptons balance sheet for December 31, 2019. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Uptons profit margin and dividend payout ratio will be the same in 2019 as they were in 2018. What is the amount of the line of credit reported on the 2019 forecasted balance sheets? (Hint: You dont need to forecast the income statements because the line of credit is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2019 addition to retained earnings for the balance sheet without actually constructing a full income statement.)arrow_forward
- Smiley Corporations current sales and partial balance sheet are shown here. Sales are expected to grow by 10% next year. Assuming no change in operations from this year to next year, what are the projected spontaneous liabilities?arrow_forwardThe Jimenez Corporation’s forecasted 2020 financial statements follow, along with some industry average ratios. Calculate Jimenez’s 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez’s projected strengths and weaknesses. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Jimenez Corporation: Forecasted Income Statement for 2020 Jimenez Corporation: Per Share Data for 2020 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year.arrow_forwardSuppose the company has just the opposite news and now expects unit sales for August, September, and October to be double (200%) the original estimates. What effect will this have on the company’s net income and borrowing? Explain your findings.arrow_forward
- Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.arrow_forwardThe Kretovich Company had a quick ratio of 1.4, a current ratio of 3.0, a days’ sales outstanding of 36.5 days (based on a 365-day year), total current assets of $810,000, and cash and marketable securities of $120,000. What were Kretovich’s annual sales?arrow_forwardRatio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license