Question

In: Finance

Construct Albert Retail Co's Pro Forma Income Statement and Balance Sheet for Years 1 to 3...

Construct Albert Retail Co's Pro Forma Income Statement and Balance Sheet for Years 1 to 3 under the following policies:

COGS+SG&A+Depreciation = 60% of Revenue

Dividend Payout = 50%

Current Assets = 40% of Revenue

Net Fixed Assets = 60% of Revenue

Current Liabilities = 70% of Current Assets

Corporate Tax Rate = 21%

Year
0(2018) 1 2 3
Revenue 150.0 195.0 253.5 253.5
COGS+SG&A+Depreciation 90.0
EBIT 60.0
Tax (21%) 12.6
Net Income 47.4
Dividends 23.7
Addition to Retained Earnings 23.7
Current Assets 60.0
Net Fixed Assets 90.0
Total Assets 150.0
Current Liabilities 42.0
Long-Term Liab - Debt 30.0

Solutions

Expert Solution

Solution:-

If you have any query related to question then feel free to ask me in a comment.Thanks.


Related Solutions

prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Phoebe's Cat Foods​ Inc.: Total asset turnover   1.6 times Average collection period (assume 365-day year)   16 days Fixed asset turnover   6 times Inventory turnover (based on cost of goods sold)   2 times Current ratio   2.0 times Sales (all on credit)   $3,000,000 Cost of goods sold   75% of sales Debt ratio   60% Fill in the assets section of the pro forma balance sheet....
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 16 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 2 times Current ratio 1.9 times Sales​ (all on​ credit) ​$5,000,000 Cost of goods sold 70​% of sales Debt ratio 40​% . Fill in the assets section of the pro forma balance...
Prepare a pro forma income statement and balance sheet for the 'coming year' for Netflix (NFLX)
Prepare a pro forma income statement and balance sheet for the 'coming year' for Netflix (NFLX)
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
Develop a pro forma income statement and balance sheet for the company given below. Use the...
Develop a pro forma income statement and balance sheet for the company given below. Use the following assumptions in making your pro forma: Currently, fixed assets are at full capacity Each asset grows proportionally with sales Payables and accruals grow proportionally with sales 2017’s profit margin (2.52%) and dividend payout (30%) will be maintained in 2018 Sales are projected to increase by $500 million (25%) Interest payments will not change (this is not realistic, but will save you some steps)...
4) Using the balance sheet from #3, construct an income statement and balance sheet for     ...
4) Using the balance sheet from #3, construct an income statement and balance sheet for      the first month of operation, given the following information:     Sales $104,000.00 Collections $77,000.00 Purchases (paid for half) $60,000.00 Ending inventory $57,000.00 Equipment Depreciation $18,000.00 Vehicle Depreciation $2,000.00 Heat (due next month) $450.00 Electricity $325.00 Telephone $230.00 Advertising $1,200.00 Salaries $15,500.00 Payroll Tax Expense $1,700.00 Office Supplies $200.00 Insurance (due next month) $1,250.00 Loan payment $3,500.00     principal $1,500.00     interest $2,000.00 Legal fees...
• Describe pro forma income and the importance of pro forma income in the evaluation of...
• Describe pro forma income and the importance of pro forma income in the evaluation of the income statement. Choose at least two items that are excluded from pro forma income. Suggest to management why including the items would be misleading to investors and creditors.
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company for 2013 and an expected sales growth rate of 6.61 % for​ 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. ​(Round to three decimal​ places.) Sales Revenue $22,811,000 ____ % Cost of goods sold $-11,638,000 ___% Selling, general, and administrative expenses $-3,973,000 ____% Depreciation expenses $ -1,369,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT