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.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 |
$40.000 |
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
MANAGEMENT ACCOUNTING
Gxsport is a small business manufactures sportswear focusing on tracksuits. Gxsportperform very well in 2021 with yearly sales amounting to RM630,000, equivalent to 12,600pieces sold. For the 1st quarter of 2022, the sales are predicted to increase by 7% ascompared to 2021’s sales due to the raised of awareness for a healthy lifestyle.The price of the tracksuit is RM50 per piece. The labour rate is RM7 per hour and eachpiece of tracksuit requires 0.4 hours to make. Manufacturing overheads are charges atRM1.50 per piece. The inventory is expected to have a balance of 500 pieces of tracksuitsas at 1st January 2022 and increase by 10% as at 31st March 2022.Calculate the production budget (in unit) for the 1st quarter 2022 (1st January to 31st March2022).
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
Using the findings provide a brief summary about the financial status of each of the companies and provide a recommendation for the investment choice.
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
- 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_forwardPlease show the excel solutions. Thank you :)arrow_forwardUsing ROI and RI to evaluate investment centers Consider the following condensed financial statements of Secure Life, Inc. The company's target rate of return is 12%. SECURE LIFE, INC. Comparative Balance Sheet As of December 31, 2021, and 2020 2021 2020 Assets Cash $ 82,000 $ 50,000 Accounts Receivable 54,000 20,500 Supplies 1,000 500 Property, Plant, and Equipment, net 275,000 180,000 Patents, net 138,000 99,000 Total Assets $ 550,000 $ 350,000 Liabilities and Stockholders' Equity Accounts Payable $ 40,000 $ 32,000 Short-term Notes Payable 135,000 45,000 Long-term Notes Payable 170,000 125,000 Common Stock, no Par 150,000 130,000 Retained Earnings 55,000 18,000 Total Liabilities and Stockholders' Equity $ 550,000 $ 350,000arrow_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_forwardvj subject-Accountingarrow_forwardWhat 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…arrow_forward
- As Financial Manager what would be your decision on assets and investment mattersto meet profit maximization? Analyze carefully and encircle your best answer.arrow_forwardFinancearrow_forwardUsing the findings, provide a brief summary about the financial status of each of the companies and provide a recommendation for the investment choice.arrow_forward
- Problem-solving 1: Cash Budget; Income Statement; Balance Sheet Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below: Minden Company Balance Sheet April 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation. Total assets f. g. Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 9,000 54.000 30,000 207,000 $300,000 $ 63,000 14,500 180,000 42,500 $300,000 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $200,000 for May. Of these sales, $60,000 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May. b. Purchases of…arrow_forwardComplete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Project B Year Cash Flow Year Cash Flow Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward…arrow_forwardhope you can answer or provide a picture. 1. Projected increase in current assets 2. Spontaneous increase in current liabilities 3. Increase in retained earnings 4. Additional fund neededarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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