Principles of Managerial Finance, Student Value Edition Plus MyLab Finance with Pearson eText - Access Card Package (15th Edition) (Pearson Series in Finance)
15th Edition
ISBN: 9780134830209
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 |
$40.000 |
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
(Learning Objectives 4, 5: Analyze current and long-term liabilities; evaluatedebt-paying ability) EnviroFriend Structures, Inc., builds environmentally sensitive structures.The company’s 2018 revenues totaled $2,780 million. At December 31, 2018, and 2017, thecompany had, respectively, $656 million and $591 million in current assets. The company’sbalance sheets and income statements reported the following amounts:
Requirements1. Describe each of EnviroFriend’s long-term liabilities and state how the liability arose.2. What were the company’s total assets at December 31, 2018? Evaluate the company’sleverage and debt ratios at the end of 2017 and 2018. Use year-end figures in place ofaverages where needed for calculating the ratios in this exercise. Did the company improve,deteriorate, or remain about the same over the year?
(Learning Objective 4: Construct the financial statements) Suppose Robin SportingGoods Company reported the following data at July 31, 2018, with amounts in thousands:Cost of goods sold................. $136,800Cash...................................... 50,000Property and equipment, net ... 19,400Common stock...................... 26,000Inventories ............................ 36,000Long-term liabilities.............. 11,700Dividends.............................. 0Retained earnings,July 31, 2017 ............ $ 31,500Accounts receivable....... 34,000Net revenues ................. 191,000Total current liabilities.. 80,000All other expenses......... 29,000Other current assets ...... 5,000Other assets................... 30,000Use these data to prepare Robin Sporting Goods Company’s single-step income statement forthe year ended July 31, 2018; statement of retained earnings for the year ended July 31, 2018;and classified balance sheet at July 31, 2018. Use the report format for the balance…
E1-23A. (Learning Objective 4: Identify financial statement by type of information) ButlerTech, Inc., is expanding into India. The company must decide where to locate and how tofinance the expansion. Identify the financial statement where these decision makers can findthe following information about Butler Tech, Inc. In some cases, more than one statement willreport the needed data.a. Revenueb. Common stockc. Current liabilitiesd. Long-term debte. Dividendsf. Ending cash balanceg. Adjustments to reconcile net income tonet cash provided by operationsh. Cash spent to acquire the buildingi. Income tax expensej. Ending balance of retained earningsk. Selling, general, and administrativeexpensel. Total assetsm. Net incomen. Income tax payable
Chapter 4 Solutions
Principles of Managerial Finance, Student Value Edition Plus MyLab Finance with Pearson eText - Access Card Package (15th Edition) (Pearson Series 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
- Learning Objective 7: Calculate return on assets) In 2018, Ambrosia Corporation LO 7reported $100 million in sales, $18 million in net income, and average total assets of $200 million.What is Ambrosia’s return on assets in 2018?arrow_forward(Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forwardE1-24A. (Learning Objective 4: Construct a balance sheet) At December 31, 2018, LandyProducts has cash of $24,000, receivables of $18,000, and inventory of $80,000. The company’sequipment totals $182,000. Landy owes accounts payable of $22,000 and long-term notespayable of $172,000. Common stock is $34,500. Prepare Landy’s balance sheet at December 31,2018, complete with its proper heading. Use the accounting equation to compute retainedearnings.arrow_forward
- (Learning Objective 4, 5: Assess the effects of transactions on a company)Suppose United Cable and Entertainment, Inc., is having a bad year in 2018, because thecompany has incurred a $4.9 billion net loss. The loss has pushed most of the company’s returnmeasures into the negative column, and its current ratio dropped below 1.0. The company’s debtratio is still only 0.27. Top management of United Cable and Entertainment is considering waysto improve the company’s ratios, including the following possible transactions:1. Selling off the cable television segment of the business for $30 million (receiving half incash and half in the form of a long-term note receivable). The book value of the cable television business is $27 million.2. Borrowing $100 million on long-term debt.3. Purchasing treasury stock for $500 million cash.4. Writing off one-fourth of the goodwill carried on the books at $128 million.5. Selling advertising at the normal gross profit of 60%. The advertisements run…arrow_forwardS1-12. (Learning Objective 4: Construct an income statement) MacKensie ServicesCorporation began 2018 with total assets of $230 million and ended 2018 with totalassets of $365 million. During 2018, MacKensie earned revenues of $394 million and hadexpenses of $171 million. MacKensie declared and paid dividends of $27 million in 2018.Prepare the company’s income statement for the year ended December 31, 2018, completewith an appropriate heading.arrow_forward(Learning Objective 4: Account for payroll expense and liabilities) Key West has anannual payroll of $150,000. In addition, the company incurs payroll tax expense of 10% of theannual payroll. At December 31, Key West owes salaries of $8,000 and FICA and other payrolltax of $1,000. The company will pay these amounts early next year. Show what Key West willreport for the foregoing on its income statement for the year and on its year-end balance sheetarrow_forward
- E3-39B. (Learning Objective 6: Analyze and evaluate liquidity and debt-paying ability) BurnesConsulting Company reported these ratios at December 31, 2018 (dollar amounts in millions):Current ratio = $20 = 2.00 $10 $60 Debt ratio = = 0.50 $30Burnes Consulting completed these transactions during 2019:a. Purchased equipment on account, $4b. Paid long-term debt, $7c. Collected cash from customers in advance, $5d. Accrued interest expense, $6e. Made cash sales, $8Determine whether each transaction improved or hurt the company’s current ratio and debt ratio.arrow_forwardE1-21A. (Learning Objectives 3, 4: Apply the accounting equation; evaluate businessoperations) Willow, Inc., has current assets of $220 million; property, plant, and equipmentof $320 million; and other assets totaling $130 million. Current liabilities are $160 million andlong-term liabilities total $380 million.Requirements1. Use these data to write Willow’s accounting equation.2. How much in resources does Willow have to work with?3. How much does Willow owe creditors?4. How much of the company’s assets do the Willow stockholders actually own?arrow_forward(Learning Objective 4: Calculate the effects of business transactions on selectedratios) Financial statement data of Greatland Engineering include the following items:Cash ........................................Short-term investments..............Accounts receivable, net............Inventories ................................Prepaid expenses.......................Total assets ...............................Short-term notes payable...........$ 26,00036,00085,000147,0006,000677,00049,000Accounts payable ......................Accrued liabilities......................Long-term notes payable ...........Other long-term liabilities.........Net income................................Number of commonshares outstanding ...........$107,00032,000163,00034,00099,00046,000Requirements1. Calculate Greatland’s current ratio, debt ratio, and earnings per share. Round all ratios totwo decimal places.2. Calculate the three ratios after evaluating the effect of each transaction that follows.Consider each…arrow_forward
- P1-70B. (Learning Objectives 2, 3, 4: Apply underlying accounting concepts; evaluatebusiness operations; construct a balance sheet) Hudson Alvarez is a realtor. He organizedhis business as a corporation on June 16, 2019. The business received $75,000 from Alvarezand issued common stock. Consider these facts as of June 30, 2019.a. Alvarez has $17,000 in his personal bank account and $44,000 in the business bankaccount.b. Alvarez owes $6,500 on a personal charge account with a local department store.c. Alvarez acquired business furniture for $17,600 on June 24. Of this amount, the business owes $9,000 on accounts payable at June 30.d. Office supplies on hand at the real estate office total $4,000.e. Alvarez’s business owes $102,000 on a note payable for some land acquired for a totalprice of $162,000.f. Alvarez’s business spent $16,000 for a Realty Experience franchise, which entitles himto represent himself as an agent. Realty Experience is a national affiliation of independent real…arrow_forwardE1-31A. (Learning Objective 4: Construct an income statement, statement of retainedearnings, and balance sheet) During 2018, Edwin Company earned revenues of $150million. Edwin incurred, during that same year, salary expense of $34 million, rent expenseof $23 million, and utilities expense of $16 million. Edwin declared and paid dividends of$16 million during the year. At December 31, 2018, Edwin had cash of $185 million, accountsreceivable of $70 million, property and equipment of $35 million, and other long-term assetsof $22 million. At December 31, 2018, the company owed accounts payable of $56 millionand had a long-term note payable of $26 million. Edwin began 2018 with a balance in retainedearnings of $73 million. At December 31, 2018, Edwin had total stockholders’ equity of$230 million, which consisted of common stock and retained earnings. Edwin has a year-end ofDecember 31. Prepare the following financial statements (with proper headings) for 2018:1. Income statement,2.…arrow_forward3-28A. (Learning Objective 6: Analyze and evaluate liquidity and debt-paying ability)Peyton Company reported these ratios at December 31, 2018 (dollar amounts in millions):Current ratio = $20 = 2.00 $10$70 Debt ratio = = 0.57 $40Peyton Company completed these transactions during 2019:a. Purchased equipment on account, $5b. Paid long-term debt, $5c. Collected cash from customers in advance, $4d. Accrued interest expense, $3e. Made cash sales, $7Determine whether each transaction improved or hurt the company’s current ratio and debt ratio.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License