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
Videos
Textbook Question
Chapter 4, Problem 4.18P
Learning Goal 5
P4-18 Pro forma
- 1. A minimum cash balance of $50,000 is desired.
- 2. Marketable securities are expected to remain unchanged.
- 3. Accounts receivable represent 10% of sales.
- 4. Inventories represent 12% of sales.
- 5. A new machine costing $90,000 will be acquired during 2020. Total
depreciation for the year will be $32,000. - 6. Accounts payable represent 14% of sales.
- 7. Accruals, other current liabilities, long-term debt, and common stock are expected to remain unchanged.
- 8. The firm’s net profit margin is 4%, and it expects to pay out $70,000 in cash dividends during 2020.
- 9. The December 31, 2019, balance sheet follows.
- a. Use the judgmental approach to prepare a pro forma balance sheet dated December 31, 2020, for Leonard Industries.
- b. How much, if any, additional financing will Leonard Industries require in 2020? Discuss.
- c. Could Leonard Industries adjust its planned 2020 dividend to avoid the situation described in part b? Explain how.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
CCC practice exercise:
The COGS of a company is 600,000. Opening inventory is 15,000 and the closing
inventory is 85,000.
Particular
2018
Annual Credit Sales
500,000
Annual credit purchases
300,000
Creditors in the beginning 65000
Creditors at the end
45000
Debtors in the beginning
80,000
Debtors at the end
100,000
You are requested to calculate the cash conversion cycle
I need the answer as soon as possible
What is the total amount of additional funding which the firm plans to take on in the year 2020?
FIN401 - Ch.12 Problems
Problem 12-9: Garlington Tech
S24 Variant
Balance Sheet
Cash
Receivables
Inventory
Total Current Assets
Net Fixed Assets
Total Assets
Accounts Payable
Line of Credit
Accruals
Total Current Liabilities
Long-term Bonds
Common Stock
Retained Earnings
Total Liabilities & Equity
AFN (external)
Cumulative AFN
Income Statement
Final
Projection
12/31/2019
12/31/2020
160,000.00
184,000
360,000.00
387,000
720,000.00
828,000
1,240,000.00
1,399,000
4,000,000.00 4,600,000
5,240,000.00 5,999,000
360,000.00
414,000
148,954.27
200,000.00
230,000
560,000.00
792,954
1,000,000.00
1,000,000
1,100,000.00 1,248,954
2,580,000.00 2,957,091
5,240,000.00 5,999,000
0.00
297,908.55
Final
Projection
12/31/2019 12/31/2020
Sales
Operating Costs
4,000,000.00 4,600,000.00
3,200,000.00 3,680,000.00
EBIT
Interest
EBT
800,000.00 920,000.00
120,000.00 137,874.51
680,000.00 782,125.49
Taxes (25)
Net…
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
- Begin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a. Using the financial statements shown here for Lan Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2020. The federal-plus-state tax rate is 25%. b. Assume there were 15 million shares outstanding at the end of 2019, the year-end closing stock price was 65 per share, and the after-tax cost of capital was 10%. Calculate EVA and MVA for 2020. Lan Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) Lan Chen Technologies: December 31 Balance Sheets (Thousands of Dollars)arrow_forwardAssume today is 15 Jan 2020. You t e the following information regarding Salalah Ceramics 31 Dec 2019 31 Dec 2020 31 Dec 2021 31 Dec 2022 Cash Flow from 12000 Operations Cash Investment 7600 Cash flow from operations will grow by 10% every year up to 2022 and cash investment will grow by 20% every year up to 2022. FCF growth after 2022 will be 5% and required return is 12%. Assuming net debt is 7000 1. What is the firm's enterprise value 2. What is the firm's value of equityarrow_forwardPro 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…arrow_forward
- Use the information provided below to prepare the following for January and February 2023: 4.1 Debtors Collection Schedule 4.2 5. 6. 7. 8. 9. 10. INFORMATION The following information was provided by Intel Enterprises: 1. 2. Cash Budget 3. 4. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable). Credit sales are expected to be as follows: December 2022 R576 000 Credit sales are normally collected as follows: 65% in the following month January 2023 Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customers receive a 10% discount. The rest is usually written off as bad debts. R540 000 * 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount. December 2022 Budgeted purchases of inventory are as follows: R1 000 000 February 2023 January 2023 R648 000 R800 000 February 2023 R920 000 Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the…arrow_forwardFrom 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_forwardplease show it on excel with excel commandarrow_forward
- lesson 9 quiz - financial planning tools and concepts pt. 2 gerry jacobs, a financial analyst for best value supermarkets, has prepared the following sales and cash disbursement estimates for the period of august through december of the current year. month sales cash disbursements august 400 300 september 500 500 october 500 700 november 600 400 december 700 500 90% of sales are for cash, the remaining 10% are collected one month later. all disbursements are on a cash basis. the firm wishes to maintain a minimum cash balance of 50. the beginning cash balance in september is 25. prepare a cash budget for the months of october, november, and december, noting any needed financing or excess cash available.arrow_forwardPro 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…arrow_forwardUsing Table 6–13, what is required in new financing if next year’s salesforecast increases to $400,000, profit margin is 10 percent, and the payoutratio is 90 percent?arrow_forward
- Intro The whole year income statement and end of year balance sheet numbers are provided for 2020. As CFO, you are to forecast 2021 numbers (blank column) based on the following assumptions: Income Balance sheet statement ($ million) ($ million) Current Sales 1,000 420 Debt 630 assets Fixed Costs 850 1,680 Equity 1,470 ? assets Net Total 150 2,100 Total 2,100 income assets Sales, assets and costs are expected to grow by 15% in 2021. The company is expected to pay NO dividend in 2021, and will keep the debt balance unchanged. Part 1 - Attempt 1/2 for 10 pts. In the forecast, which of the following financial ratios are assumed unchanged throughout 2020-2021? Must select ALL to earn points. Check all that apply: O debt-equity ratio O profit margin total asset turnover O ROE O gross profit margin accounts receivable turnoverarrow_forwardREQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for January and February 2021. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION The bank balance on 31 December 2020 is expected to be R40 000 (favourable). Expected credit sales are as follows: December 2020 R360 000 1. 2. 3. 4. 5. 6. 7. 8. 9. * * January 2021 R390 000 February 2021 R420 000 11 Credit sales usually make up 60% of the total sales. Cash sales make up the balance. Credit sales are normally collected as follows: 20% in the month in which the transaction took place. These debtors are entitled to a 5% discount. 75% in the following month. The rest is usually written off as bad debts. The mark-up is 25% on cost. The goods that are sold each month are replaced in the same month. The ratio of cash purchases to credit purchases is 3:1 respectively. Creditors are paid in the month after the…arrow_forwardAdditional Funds Needed Version C The Tigers Inc.'s sales are forecasted to double from $900 in 2020 to $1800 in 2021 (that is, a 100% |increase). The 2020 Balance sheet for Tigers Inc., is shown here: 2020 Balance Sheet Cash $ 50 Account payable 100 Account receivable $ 250 Notes payable $ 150 $ $ Long-term debt Common stock $ $ $ Inventories 250 400 Net fixed assets 500 150 Retained earnings 250 Total assets $ 1,050 Total liabilities and equity $ 1,050 Assume that Tigers' fixed assets were used to 100% capacity and that its current assets were at their proper levels in relation to sales. Tigers' after-tax profit margin (i.e. NI/ Sales) is forecasted to |be 8% and its payout ratio to be 40%. Sales 2020 = Sales 2021 = NI/Sales = Payout ratio = $ 900 $ 1,800 8% 50% What is Tigers' additional funds needed (AFN) for 2021? Round your answer to the nearest dollar. %24arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
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