Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.19P
Learning Goal 5
P4-19 Pro forma
- 1. The percent of sales for items that vary directly with sales are as follows:
Accounts receivable, 12%
Inventory, 18%
Accounts payable, 14%
Net profit margin, 3%
- 2. Marketable securities and other current liabilities are expected to remain unchanged.
- 3. A minimum cash balance of $480,000 is desired.
- 4. A new machine costing $650,000 will be acquired in 2020, and equipment costing $850,000 will be purchased in 2021. Total depreciation in 2020 is
forecast as $290,000, and in 2021 $390,000 of depreciation will be taken. - 5. Accruals are expected to rise to $500,000 by the end of 2021.
- 6. No sale or retirement of long-term debt is expected.
- 7. No sale or repurchase of common stock is expected.
- 8. The dividend payout of 50% of net profits is expected to continue.
- 9. Sales are expected to be $11 million in 2020 and $12 million in 2021.
- 10. The December 31, 2019, balance sheet follows.
- a. Prepare a pro forma balance sheet dated December 31, 2021.
- b. Discuss the financing changes suggested by the statement prepared in part a.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Pro forma balance sheet Peabody & Peabody has
2019
sales of
$10.5
million. It wishes to analyze expected performance and financing needs for
2021—2
years ahead. Given the following information, respond to parts a. and b.
(1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable;
11.9%,
Inventory;
17.7%;
Accounts payable,
13.6%;
Net profit margin,
3.5%.
(2) Marketable securities and other current liabilities are expected to remain unchanged.
(3) A minimum cash balance of
$482,000
is desired.
(4) A new machine costing
$653,000
will be acquired in
2020,
and equipment costing
$848,000
will be purchased in
2021.
Total depreciation in
2020
is forecast as
$288,000,
and in
2021
$388,000
of depreciation will be taken.
(5) Accruals are expected to rise to
$504,000
by the end of
2021.
(6) No sale or retirement of long-term debt is expected.
(7) No sale or repurchase of common stock is expected.
(8) The dividend payout of…
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10 million. It wishes to analyze expected performance and financing needs for 2021, which is 2 years ahead. Given the following information, respond to parts a and b.
(1) The percent of sales for items that vary directly with sales are as follows: Accounts receivable, 12% Inventory, 18% Accounts payable, 14% Net profit margin, 3%
(2) Marketable securities and other current liabilities are expected to remain unchanged.
(3) A minimum cash balance of $480,000 is desired.
(4) A new machine costing $650,000 will be acquired in 2020, and equipment costing $850,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $290,000, and in 2021 $390,000 of depreciation will be taken.
(5) Accruals are expected to rise to $500,000 by the end of 2021.
(6) No sale or retirement of long-term debt is expected.
(7) No sale or repurchase of common stock is expected.
(8) The dividend payout of 50% of net profits is expected to…
Executive Summary of findings-assessment of which firm would be the better investment based on the above comparison.
If answered within 45mins,it would be helpful!!!
Chapter 4 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Ch. 4.1 - Prob. 4.1RQCh. 4.1 - Prob. 4.2RQCh. 4.2 - Briefly describe the first four modified...Ch. 4.2 - Describe the overall cash flow through the firm in...Ch. 4.2 - Prob. 4.5RQCh. 4.2 - 4-B Why is depreciation (as well as amortization...Ch. 4.2 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Learning Goal 5 E4-5 Rimier Corp. forecasts sales...Ch. 4 - Prob. 4.1PCh. 4 - Learning Goal 2 P4-2 Depreciation In early 2019,...Ch. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.11PCh. 4 - Learning Goal 4 P4-12 Cash budget: Advanced The...Ch. 4 - Prob. 4.13PCh. 4 - Prob. 4.14PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Learning Goal 5 P4-16 Pro forma income statement...Ch. 4 - Learning Goal 5 P4-17 Pro forma income statement:...Ch. 4 - Learning Goal 5 P4-18 Pro forma balance sheet:...Ch. 4 - Learning Goal 5 P4-19 Pro forma balance sheet...Ch. 4 - Learning Goal 5 P4-20 Integrative: Pro forma...Ch. 4 - Learning Goal 5 P4-21 Integrative: Pro forma...Ch. 4 - Prob. 4.22PCh. 4 - Prob. 1SE
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
- A. Wally asks you to create an Income Statement for 2020 using the information below. 1. 2020 sales were 150% of last year’s sales2. Gross profit margin was 55%3. Operating profit margins were 15% 4. Interest expense fell to 7%, given a change in interest rates 5. The tax rate was 30% B. Based on the change in Income between 2020 and 2019, how would you say AndrewCo is doing?arrow_forwardPercentage of Sales Models Here are the abbreviated financial statements for Planner's Peanuts Income Statement , 2019 Sales $2,000 Cost 1,500 Net Income $ 500 Balance Sheet, Year End 2018 2019 2018 2019 Assets $2,500 $3,000 Debt $ 833 $1,000 Equity 1,667 2,000 Total $2,500 $3,000 Total $2,500 $3,000 a. if sales increase by 20% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 20%), what must be the balancing item? b. what will be the value of this balancing item?arrow_forwardAnalyze credit risk in the past and current years Analyze profitability in the past and current yearsarrow_forward
- From the balance sheet prepare a proforma income statement where revenues can increase by 2% and the firm can borrow at 5.5% BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other CA 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciations 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Pro-forma statement Pro Forma Forecasts Actual Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 COGS/REVENUES SGA/SALES INVENTORIES/COGS OTHER CA/SALES AR/SALES AP/COGS SALES/FIXED ASSETS DEPR/ FIXED ASSETS EQUITY/INVESTED CAPITAL ST DEBT/INVESTED…arrow_forwardHere are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2019 Sales $ 3,500 Cost 2,700 Net income $ 800 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 Assets $ 4,500 $ 5,000 Debt $ 833 $ 1,000 Equity 3,667 4,000 Total $ 4,500 $ 5,000 Total $ 4,500 $ 5,000 Assume the payout ratio is 50%. a. Calculate the internal growth rate where no external debt or equity is to be issued. (Do not round intermediate calculations. Enter your answer as a whole percent.) b. Calculate the sustainable growth rate where the firm maintains a fixed debt ratio but issues no equity. (Do not round intermediate calculations. Enter your answer as a whole percent.)arrow_forward(Profitability Ratio)What is the Return on Investment Ratio in 2019?arrow_forward
- Here are the abbreviated financial statements for Planner's Peanuts: INCOME STATΕΜENT, 2019 $6,000 4,700 Sales Cost Net income $1,300 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 $9,500 $14,300 $ 8,567 933 $1,000 13,300 Assets Debt Equity Total $9,500 $14,300 Total $9,500 $14,300 a. If sales increase by 10% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 10%), what must be the balancing item? b. What will be the value of this balancing item? Balancing item а. b. Valuearrow_forwardConsider whether actual performance has improved since 2019 (actual 2021 vs. 2019) Consider whether the performance achieved is as good as Sonik intended (actual 2021 vs. budget 2021) and how it compares to the market leaderarrow_forward1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019 income statement and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: (1) sales in FY 2019 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share. Use your judgment on all other items. a. What is the discretionary financing needed in 2019? Is this a surplus or deficit? b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.arrow_forward
- c. Calculate the profitability ratio which includes gross profit margin, operating profit margin, net profit margin, and NOPAT marginarrow_forwardCalculate the profit margin (net income or net profit/total sales)for Rock Castle construction for this fiscal year. What’s the percentagearrow_forwardHello, just need help on net income and return on equityarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Dividend disocunt model (DDM); Author: Edspira;https://www.youtube.com/watch?v=TlH3_iOHX3s;License: Standard YouTube License, CC-BY