Question One PRISCILLA AND NIINA ENTERPRISE VALUE DRIVERS/INPUT DATA: ITEM Sales Growth Rate Inventory / sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question One PRISCILLA AND NIINA ENTERPRISE VALUE DRIVERS/INPUT DATA: ITEM Sales Growth Rate Inventory / sales Accounts Receivables/ sales Accruals/Sales Accounts Payables/ Sales Notes Payable/ sales Increment in Capital Expenditure / Sales Cost of Goods sold/Sales Depreciation of Capital Expenditure on straight line life Interest rate on debt balance Interest earned on cash balance Tax Rate Shares Outstanding Dividend Payout Policy ITEMS Sales or Revenue Cost of Goods Sold (COGS) Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Expense Earnings before interest and taxes (EBIT) Less interest on Debt Interest earned on cash and cash equivalents Earnings Before Taxes (EBT) Taxes Year 2021 ΝΑ 14% 10.5% 4.0% 1.0% 2.0% NA 50.0% INCOME STATEMENT FOR PRISCILLA AND NIINA ENTERPRISE Year 2022 3,000.00 (1,500.00) Earnings After Tax (EAT) Dividends Net Income available to common stockholders - Retained Earnings ΝΑ 10.0% 7.0% 35.0% 1,000.00 30.0% 1,500.00 (100.00) 1,400.00 (88.00) 12.30 1,324.30 (78.32) 117.48 (4.00) Year 2022 20.0% 14.0% 10.5% 4.0% 1.0% 2.0% 113.48 5.00% 50.0% 10 10.0% 7.0% 35.0% 1,000.00 30.0% Year 2022 3,600.00 (1,800.00) 1,800.00 (118.00) 1,682,00 (58.00) 27.99 1,651.99 (578.20) 1,073.79 322.14 751.65 Assets Cash and marketable securities Accounts receivable Inventories Total current assets Plant and equipment at cost Accumulated Depreciation Net Plant and Equipment Total assets Total Liabilities and Equities Accounts Payable Notes payable Accruals Total current liabilities Long-term bonds Total debt Preferred stock (400,000 shares) Common stock (50,000,000 shares) Retained earnings Tot common equity Total liabilities and equity Year 2021 80.00 315.00 415.00 810.00 900.00 (30.00) 870.00 1,680.00 30.00 60.00 130.00 220.00 580.00 800.00 40.00 130.00 710.00 840.00 1,680.00 Year 2022 719.65 378.00 504.00 1,601.65 1,080.00 (218.00) 862.00 2,463.65 36.00 72.00 144.00 252.00 580.00 832.00 40.00 130.00 1,461.65 1,631.65 2,463.65 Requirement: Use the above financial statements to answer the following questions: a) Estimate free cash flows for Priscilla and Niina Enterprise for the year 2022 using: Earnings before interest and taxes (EBIT) as your starting point. (5 marks) i) ii) Earnings before interest, depreciation, taxes and ammortization (EBITDA) as (5 marks) your starting point. b) Compute the common size income statement and balance sheet for the year 2022 only. (10 marks) || Question One PRISCILLA AND NIINA ENTERPRISE VALUE DRIVERS/INPUT DATA: ITEM Sales Growth Rate Inventory / sales Accounts Receivables/ sales Accruals/Sales Accounts Payables/ Sales Notes Payable/ sales Increment in Capital Expenditure / Sales Cost of Goods sold/Sales Depreciation of Capital Expenditure on straight line life Interest rate on debt balance Interest earned on cash balance Tax Rate Shares Outstanding Dividend Payout Policy ITEMS Sales or Revenue Cost of Goods Sold (COGS) Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Expense Earnings before interest and taxes (EBIT) Less interest on Debt Interest earned on cash and cash equivalents Earnings Before Taxes (EBT) Taxes Year 2021 ΝΑ 14% 10.5% 4.0% 1.0% 2.0% NA 50.0% INCOME STATEMENT FOR PRISCILLA AND NIINA ENTERPRISE Year 2022 3,000.00 (1,500.00) Earnings After Tax (EAT) Dividends Net Income available to common stockholders - Retained Earnings ΝΑ 10.0% 7.0% 35.0% 1,000.00 30.0% 1,500.00 (100.00) 1,400.00 (88.00) 12.30 1,324.30 (78.32) 117.48 (4.00) Year 2022 20.0% 14.0% 10.5% 4.0% 1.0% 2.0% 113.48 5.00% 50.0% 10 10.0% 7.0% 35.0% 1,000.00 30.0% Year 2022 3,600.00 (1,800.00) 1,800.00 (118.00) 1,682,00 (58.00) 27.99 1,651.99 (578.20) 1,073.79 322.14 751.65 Assets Cash and marketable securities Accounts receivable Inventories Total current assets Plant and equipment at cost Accumulated Depreciation Net Plant and Equipment Total assets Total Liabilities and Equities Accounts Payable Notes payable Accruals Total current liabilities Long-term bonds Total debt Preferred stock (400,000 shares) Common stock (50,000,000 shares) Retained earnings Tot common equity Total liabilities and equity Year 2021 80.00 315.00 415.00 810.00 900.00 (30.00) 870.00 1,680.00 30.00 60.00 130.00 220.00 580.00 800.00 40.00 130.00 710.00 840.00 1,680.00 Year 2022 719.65 378.00 504.00 1,601.65 1,080.00 (218.00) 862.00 2,463.65 36.00 72.00 144.00 252.00 580.00 832.00 40.00 130.00 1,461.65 1,631.65 2,463.65 Requirement: Use the above financial statements to answer the following questions: a) Estimate free cash flows for Priscilla and Niina Enterprise for the year 2022 using: Earnings before interest and taxes (EBIT) as your starting point. (5 marks) i) ii) Earnings before interest, depreciation, taxes and ammortization (EBITDA) as (5 marks) your starting point. b) Compute the common size income statement and balance sheet for the year 2022 only. (10 marks) ||
Expert Answer:
Answer rating: 100% (QA)
a i Free Cash Flow FCF using EBIT EBIT 140000 Depreciation 11800 Taxes 7832 Capital Expenditures 220... View the full answer
Related Book For
Principles of Accounting
ISBN: 978-1133626985
12th edition
Authors: Belverd E. Needles, Marian Powers and Susan V. Crosson
Posted Date:
Students also viewed these accounting questions
-
Net sales are $400,000, cost of goods sold is $310,000, operating expenses are $60,000 and other revenues are $5,200. What are the gross profit margin and profit margin? a. 22.5% and 7.5% b. 7.5% and...
-
Inventory turnover is calculated as cost of goods sold divided by ending inventory . 1. True 2. False
-
Sales for 2017 were $245,000, and the cost of goods sold was 60 percent of sales Selling and administrative expense was $24,500 Depreciation expense was 8 percent of plant and equipment (gross) at...
-
Solve the following initial value problem. y" + 2y + 17y=0; y(0) = 1, y'(0) = -1
-
Rooney Corporation issued 3,000 7%, 5-year, $1,000 bonds dated January 1, 2014, at face value. Interest is paid each January 1. (a) Prepare the journal entry to record the sale of these bonds on...
-
Solve. 1. Find the quotient of 94 and 7. 2. Find 116 divided by 32. 3. Find the quotient of 78 and 5.
-
Carbon is the sixth element in the periodic table. How many protons and how many neutrons are there in a nucleus of the isotope 14 C?
-
Wal-Mart Stores, Inc. (Walmart) is the largest retailing firm in the world. Building on a base of discount stores, Walmart has expanded into warehouse clubs and Supercenters, which sell traditional...
-
How many pints of milk must be purchased for 148 servings, if each person is to receive 4.8 ounce glass? show your solution
-
A bank's balance sheet information is shown below (in $000). 1. What is the bank's risk-adjusted asset base under Basel III? 2. To be adequately capitalized, what are the bank's CET1, Tier I, and...
-
What are the similarities between state and government?
-
Retraite Co. has the given data available regarding its pension. interest cost Actual interest earned 3 Amount fundea Yeor 1 300,000 8% 12% 10% 330,000 Year 2 340,000 8% 12% 10% 360.000 What is...
-
2. InvestPros, Inc., just paid a dividend of $3.00 per share. You expect the dividend to increase by 20% next year, 10% the following two years, and then 4% thereafter. If you require a rate of...
-
Design a sequence generator that generates the following serial sequence: If your Entry no. is 2021EE1X1X2X3X4, then the serial sequence to be generated is: {3-bit binary of (X3%8), 3-bit binary of...
-
A wood block cube of each side 0.5 m floats in a water reservoir. Given that the densities of wood and water are 800 and 1000 kg/m respectively. Calculate: (i) The weight of water displaced by the...
-
What is the aperture diameter of a 18-mm-focal-length lens set to F5.0 ? Discuss.
-
- Given the following data for Taylor Coffee Shop, use the high-low method to determine the variable cost per unit (cup of coffee), total fixed costs, and the estimated total cost formula or total...
-
In Exercises evaluate the limit, using LHpitals Rule if necessary. lim 07x cos x X
-
Cos Cob Systems, Inc., makes heat-seeking missiles. It has recently been offered a government contract from which it may realize a profit. The contract purchase price is $130,000 per missile, but the...
-
Clean Plate Company produces placemats. Each placemat calls for 0.2 meters of vinyl material; the material should cost $1 per meter. In June, the company manufactured and sold 100,000 placemats....
-
Record the following transactions using T accounts, assuming the periodic inventory system is used: Aug. 4 Sold merchandise on credit to Rock Company, terms n/30, FOB destination, $2,520. 5 Paid...
-
Describe the basic difference between the systems of courts in the United States and in Canada.
-
Motion pictures and television programs are responsible for a misconception about the way in which trials proceed. Explain.
-
What is a class action and when do parties use them?
Study smarter with the SolutionInn App