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.20P
Learning Goal 5
P4-20 Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available:
- 1. The firm has estimated that its sales for 2020 will be $900,000.
- 2. The firm expects to pay $35,000 in cash dividends in 2020.
- 3. The firm wishes to maintain a minimum cash balance of $30,000.
- 4. Accounts receivable represent approximately 18% of annual sales.
- 5. The firm's ending inventory will change directly with changes in sales in 2020.
- 6. A new machine costing $42,000 will be purchased in 2020. Total depreciation for 2020 will be $17,000.
- 7. Accounts payable will change directly in response to changes in sales in 2020.
- 8. Taxes payable will equal one-fourth of the tax liability on the pro forma income statement.
- 9. Marketable securities, other current liabilities, long-term debt, and common stock will remain unchanged.
- a. Prepare a pro forma income statement for the year ended December 31, 2020, using the percent-of-sales method.
- b. Prepare a pro forma
balance sheet dated December 31, 2020, using the judgmental approach. - c. Analyze these statements, and discuss the resulting external financing required.
Red Queen Restaurants Income Statement for the Year Ended December 31 2019
Sales revenue | $800,000 |
Less: Cost of goods sold | 600,000 |
Gross profits | $200,000 |
Less: Operating expenses | 100,000 |
Net profits before taxes | $100,000 |
Less: Taxes (rate = 40%) | 40,000 |
Net profits after taxes | $60,000 |
Less: Cash dividends | 20,000 |
To retained earnings | $40.000 |
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial
performance and identify areas for making decisions for improvement
REQUIREMENT: Financial Statement Analysis
Question
Refer to the following financial statements of Delima Corporation for 2019 and 2020:
Delima Corporation
Income Statements
For the year ended 31 December (in millions)
2020
$13,198
7,750
2019
$12,397
7,108
Net sales
Cost of goods sold
Gross profit
Selling and administrative expenses
Income from operations
5,448
5,289
3,472
3,299
1,976
1,990
Interest expense
233
248
Other (income) expense, net
11
1,732
503
1,229
Income before income taxes
1,742
Income tax expense
502
Net income
1,240
Delima Corporation
Balance Sheets
31 December (in millions)
2020
2019
Assets
Current assets
Cash
$460
$444
Accounts receivables (net)
1,188
1,132
1,190
1,056
225
2,915
3,128
Inventories
Other current assets
247
Total current assets
3,027
3,281
Property (net)
5,593
$11,901
Other assets…
https://www.republictt.com/pdfs/annual-reports/RFHL-Annual-Report-2022.pdf
Working Capital Management: Use Republic Bank Limited Annual Report 2022 to answer the Questions.
Assess the company’s working capital position by analyzing its current assets and liabilities using common methods and measures.
Evaluate the efficiency of the company’s working capital management strategies, including inventory management, accounts receivable, and accounts payable.
Based on your assessment and evaluation above, provide brief recommendations in point form for improving the company’s working capital management practices.
(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?
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
- https://www.republictt.com/pdfs/annual-reports/RFHL-Annual-Report-2022.pdf Financial Reporting Analysis: Use Republic Bank Limited Annual Report 2022 to answer the Questions. Assess the company’s working capital position by analyzing its current assets and liabilities using common methods and measures. Evaluate the efficiency of the company’s working capital management strategies, including inventory management, accounts receivable, and accounts payable. Based on your assessment and evaluation above, provide brief recommendations in point form for improving the company’s working capital management practices.arrow_forwardUsing Excel for financial statement analysis Download an Excel temp/ate for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren Riverside Sweets, a retail candy store chain, reported the following figures: Additional financial information: a. 75% of net sales revenue are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Requirements Perform a horizontal analysis on the balance sheet for 2018 and 2019. Perform a vertical analysis on the income statement. Compute the following ratios: a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o. Asset…arrow_forwardhttps://www.republictt.com/pdfs/annual-reports/RFHL-Annual-Report-2022.pdf (Use the link the answer the question below) Working Capital Management : Use Republic Bank Limited Annual Report 2022 to answer the Questions. Assess the company’s working capital position by analyzing its current assets and liabilities using common methods and measures. Evaluate the efficiency of the company’s working capital management strategies, including inventory management, accounts receivable, and accounts payable. Based on your assessment and evaluation above, provide brief recommendations in point form for improving the company’s working capital management practices.arrow_forward
- (Learning Objective 5: Differentiate financing with debt vs. equity) OrchardMedical Goods is embarking on a massive expansion. Assume the plans call for opening20 new stores during the next two years. Each store is scheduled to be 30% larger than thecompany’s existing locations, offering more items of inventory and with more elaborate displays. Management estimates that company operations will provide $1.0 million of the cashneeded for expansion. Orchard Medical must raise the remaining $4.75 million from outsiders.The board of directors is considering obtaining the $4.75 million either by borrowing at 4%or by issuing an additional 200,000 shares of common stock. This year the company has earned$5 million before interest and taxes and has 200,000 shares of $1-par common stock outstanding. The market price of the company’s stock is $23.75 per share. Assume that income beforeinterest and taxes is expected to grow by 30% each year for the next two years. The company’smarginal income tax…arrow_forwardDesign 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_forwardAs Financial Manager what would be your decision on assets and investment matters to meet profit maximization? Analyze carefully and encircle your best answer. A financial manager must choose between four alternative Assets: 1, 2, 3, and 4. Each asset costs P35,000 and is expected to provide earnings over three years as described below. 1. Based on the profit- maximization goal, the financial manager would choose ASSET YEAR YEAR A. Asset 1 1 2 B. Asset 2 21,000 | 15,000 | 6,000 9,000 15,000 | 21,000 3,000 20,000 | 19,000 6,000 12,000 | 12,000 1 C. Asset 3 2 D. Asset 4 4arrow_forward
- REQUIRED Use the information provided below to prepare the following for Protea Limited for January, February and March 2023: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION Protea Limited is in the process of formulating plans for the first quarter of 2023. 1. The following sales figures show the growth expected: Year Month 2022 December 2023 January 2023 February 2023 March 2. 3. Sales R460 000 R560 000 R640 000 R720 000 7. Forty percent (40%) of the sales is expected to be for cash and the balance is on credit. Twenty percent (20%) of the credit sales is expected to be collected in the month of the sale and 75% in the month after the sale. The remaining 5% is usually written off as bad debts. Debtors who settle their accounts in the month of the sale are entitled to a 5% discount. 4. The purchase of inventory is the company's largest expenditure and the cost of these items equals 60% of the current month's sales (excluding any discounts). Sixty percent (60%) of the…arrow_forwardDon Williams received a memo requesting that he complete a trend analysis of the following numbers using 2021 as the base year. 2024 $335,800 180,000 66, 700 Sales Gross profit Net income Could you help Don with the request? 2024 Sales Gross profit Net income % % % 2023 $ 391,000 234,000 85,100 2023 % % % 2022 2021 $409,400 $ 460,000 324,000 360,000 39, 100 46,000 2022 % % % 2021 100 % 100 % 100 %arrow_forwardA. The following information is extracted from Merry Hotel’s management report for themonth of January 2022. USD Beginning cash balance 8,200 Budgeted revenue 13,000 Purchase of inventory by cash 4,500 Cash repayment of bank loan 5,800 Additional information, 70% of Sosana Hotel’s revenue is received in cash and theremaining 30% on credit. All credit sales are expected to be collected in the followingmonth. Assume that there were no credit sales and credit purchases in December 2021.Based on the given information, prepare a cash budget for the month ended 31st January2022 to calculate ending cash balance.arrow_forward
- You must type in both the answer and all of your work to receive credit. Use the financial statements and additional data provided by management to calculate the firm's Free Cash Flow for the projected year. • Tax rate = 25% • Plans for the projected year will require $500 of new machinery and equipment • Firm expects next year's dividend to be $260 Acme Products, Inc. Balance Sheets ASSETS Cash Receivables Inventory Property, plant & equipment Total assets LIABILITIES & EQUITY Accounts payables Accrued expenses Long-term debt Common stock Paid-in Capital Retained earnings Total liabilities and equity current yr 400 600 900 2,200 4,100 500 400 1,400 600 200 1,000 4,100 projected yr 500 750 1,125 2,750 Acme Products, Inc. Income Statement Operating expenses 5,125 Depreciation 5,125 Sales (all credit) Cost of Goods Sold Gross Profit Operating income Interest expense 625 Taxable income 500 Taxes (25%) 1,750 Net income 750 250 1,250 projected yr 7,000 4,000 3,000 1,400 400 1,200 100 1,100…arrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022 Month 2021 - 2022 Cash Sales $ Sales on A/C $ Cash Purchases $ Purchases on A/C $ Nov 2021 138,100 480,000 345,000 Dec 2021 156,500 600,000 25,800 380,000 Jan 2022 170,975 650,000 44,625 400,000 Feb 2022 135,740 700,000 30,400 480,000 Mar 2022 226,420 800,000 55,100 540,000 1 Extracts from the sales and purchases budgets are as follows 2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90 55% in the month of sale 35% in the first month…arrow_forwardAssume 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License