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
Textbook Question
Chapter 4, Problem 4.18P
Learning Goal 5
P4-18 Pro forma balance sheet: Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered:
- 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 solutionStudents have asked these similar questions
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…
Assume 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 equity
Striker Company estimates its expected cash receipts for the period to be $80,000 and its expected cash disbursements to
be $70,000. The beginning cash balance for the period was $5,000. The management wants to maintain a minimum cash
balance of $40,000.
Knowledge Check 01
How much cash will the company need to borrow?
O $15,000
O $25,000
O $30,000
O $40,000
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_forwardPLC estimate a cash of $2 500 000 over the next five months. This amount is available to the firm in the form of marketable securities. It can earn 10% annual yield on its marketable securities. Conversion of marketable securities into cash entails a fixed cost of $750 per transaction.Determine:i. Optimum cash balance ii. Average cash holding iii. Number of transactions iv. Average number of days per transaction (assume 30 days per month) v. Total cost of holding cash balance vi. Per day usage of casharrow_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
- Design a spreadsheet for the preparation of projected income statements, balance sheets, and statements of cash flows for MSC for Year 8Year 12. Also forecast the financial statements for each of these years under three scenarios: (1) best case, (2) most likely, and (3) worst case. The following sections describe the assumptions you can make.arrow_forwardCalculate the risk-weighted asset for this amount. A Commercial Banking business line (15%) that reports positive profits in the last 3 years: $750,000.00 in 2017, $600,000.00 in 2018, $300,000.00 in 2019. For $550,000.00 MXN Select one: a.$82,500.00 MXN. b.$99,000.00 MXN. c.$28,500.00 MXN. d.$66,000.00 MXN.arrow_forwardYears Bank Total Asset 2018 STANBIC 6,205,018 2019. STANBIC. 9,295,682 2020. STANBIC 12,742,132 2018. BARCLAYS 8,994,562 2019. ABSA 11,772,546 2020. ABSA. 12,546,473 Calculate the Herfindahl-Hirschman Index (HHI) for each year using total assets and comment on the level of competitionarrow_forward
- Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following:a. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.arrow_forwardFiscal year is January-December. All values PHP Millions. 2020 2019 Cash & Short Term Investments 57,461 23,022 Cash Only 21,361 20,892 Short-Term Investments 36,100 2,130 Cash & Short Term Investments Growth 149.59% -4.75% Cash & ST Investments / Total Assets 27.26% 12.28% Total Accounts Receivable 7,050 5,906 Accounts Receivables, Net 5,796 5,370 Accounts Receivables, Gross 6,455 5,762 Bad Debt/Doubtful Accounts -659 -392 Other Receivables 1,253 537 Accounts Receivable Growth 19.36% 21.46% Accounts Receivable Turnover 18.34 30.41 Inventories 10,727 12,016 Finished Goods - 9,116 Raw Materials 7,680 228 Progress Payments & Other 3,048 2,673 Other Current Assets 4,802 4,675 Prepaid Expenses 4,661 4,436 Miscellaneous Current Assets 141 239 Total Current Assets 80,041 45,619 Net Property, Plant & Equipment…arrow_forwardFiscal year is January-December. All values PHP Millions. 2020 2019 Cash & Short Term Investments 57,461 23,022 Cash Only 21,361 20,892 Short-Term Investments 36,100 2,130 Cash & Short Term Investments Growth 149.59% -4.75% Cash & ST Investments / Total Assets 27.26% 12.28% Total Accounts Receivable 7,050 5,906 Accounts Receivables, Net 5,796 5,370 Accounts Receivables, Gross 6,455 5,762 Bad Debt/Doubtful Accounts -659 -392 Other Receivables 1,253 537 Accounts Receivable Growth 19.36% 21.46% Accounts Receivable Turnover 18.34 30.41 Inventories 10,727 12,016 Finished Goods - 9,116 Raw Materials 7,680 228 Progress Payments & Other 3,048 2,673 Other Current Assets 4,802 4,675 Prepaid Expenses 4,661 4,436 Miscellaneous Current Assets 141 239 Total Current Assets 80,041 45,619 Net Property, Plant & Equipment…arrow_forward
- Problem 2 ABM Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the perio 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.arrow_forwardevious Ned You are a financial Manager of Chevron Corp You need to assess the effectiveness of working capital management of the company for 2018 using the following data What is the 2018 Cash Conversion Cycle using 365 days? 2017 Account Recevable-15.653 000 2018 Account Receivable=15:050 000 2017 Inventory= 5 585 000 2018 Inventory = 5704 000. 2017 Accounts Payable 14.565 000 2018 Accounts Payable 13 053 000 2017 Sales134674 000 2018 Sales 158 902 000 2017 Cost of Sales=9511430 2018 COs oSales = 1:3997 0 2017 Purchases 2018 Purchases 總 I99arrow_forwardQuantitative Problem 1: Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1-T)] will be $400 million and its 2020 depreciation expense will be $60 million. Barrington's 2020 gross capital expenditures are expected to be $120 million and the change in its net operating working capital for 2020 will be $25 million. The firm's free cash flow is expected to grow at a constant rate of 5.5% annually. Assume that its free cash flow occurs at the end of each year. The firm's weighted average cost of capital is 8.1%; the market value of the company's debt is $2.85 billion; and the company has 190 million shares of common stock outstanding. The firm has no preferred stock on its balance sheet and has no plans to use it for future capital budgeting projects. Also, the firm has zero non-operating assets. Using the corporate valuation model, what should be the company's stock price today (December 31, 2019)? Do not round intermediate…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningIntermediate 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 LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher: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
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license