CHAPTER 10: FINANCIAL FORECASTING AND PLANNING QUESTION AND ANSWER ST-1. (Financial forecasting) Use the percent of sales method to prepare a pro forma income statement for Calico Sales Co. Inc. Projected sales for next year equal $4 million. Cost of goods sold equals 70 percent of sales, administrative expense equals $500,000, and depreciation expense is $300,000. Interest expense equals $50,000, and income is taxed at a rate of 40 percent. The firm plans to spend $200,000 during the period to renovate its office facility and will retire $150,000 in notes payable. Finally, selling expense equals 5 percent of sales.

CHAPTER 10: FINANCIAL FORECASTING AND PLANNING QUESTION AND ANSWER ST-1. (Financial forecasting) Use the percent of sales method to prepare a pro forma income statement for Calico Sales Co. Inc. Projected sales for next year equal $4 million. Cost of goods sold equals 70 percent of sales, administrative expense equals $500,000, and depreciation expense is $300,000. Interest expense equals $50,000, and income is taxed at a rate of 40 percent. The firm plans to spend $200,000 during the period to renovate its office facility and will retire $150,000 in notes payable. Finally, selling expense equals 5 percent of sales.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Global Corp. expects sales to grow by 7% next year. Using the percent of sales method and the data provided in the given tables LOADING... , forecast: a. Costs except depreciation b. Depreciation c. Net income d. Cash e. Accounts receivable f. Inventory g. Property, plant, and equipment h. Accounts payable (Note: Interest expense will not change with a change in sales. Tax rate is 26%.) The Tax Cuts and Jobs Act of 2017 temporarily allows 100% bonus depreciation (effectively expensing capital expenditures). However, we will still include depreciation forecasting in this chapter and in these problems in anticipation of the return of standard depreciation practices during your career. Income Statement Net Sales 185.3Costs Except Depreciation -175.4EBITDA 9.9Depreciation and Amortization -1.2EBIT 8.7Interest Income (expense) -7.7Pretax Income 1Taxes (26%) -0.3Net Income 0.7 Balance Sheet Assets Cash 23.4Accounts…
calculate the • efficiency ratios, • liquidity ratios, • leverage ratios, and • profitability ratios for KPC Corporation for this year. Where data is available, also calculate ratios for last year. Use a 360-day year. All sales are on credit to business customers. Assume an income tax rate of 30 percent.
Using the AFN formula approach, calculate the total assets of Harmon Photo Company given the following information: Sales this year = $3,000; increase in sales projected for next year = 20%; net income this year = $250; dividend payout ratio = 40%; projected excess funds available next year = $100; accounts payable = $600; notes payable = $100; and accrued wages and taxes = $200. Except for the accounts noted, there were no other current liabilities. Assume that the firm’s profit margin remains constant and that the firm is operating at full capacity. $3,000 $2,200 $2,000 $1,200 $1,000
calculate the efficiency ratios, liquidity ratios, leverage ratios, and profitability ratios for KPC Corporation for this year. Where data is available, also calculate ratios for last year. Use a 360-day year. All sales are on credit to business customers. Assume an income tax rate of 30 percent.
1.2. What Is the internlal growth ate (IGR)? interpret. 2) The net income is RO 25,000. Last year's sales were RO 180,000. The total assets represent half (50%) of total sales. The accounts payables represent 10% of total assets. The accruals is RO 2,000 and the notes payables is RO 3,000. The assets and costs vary directly with sales. The firm distributes RO 15,000 dividends. The firm operates at full capacity. If the sales growth rate is 15%, how much external financing is needed? Interpret.
Using the AFN formula in financial forecasting approach, Determine the following for Piano Co. given the following accounting information assuming that the firm’s profit margin remains constant and the company is at full capacity. · Sales this year is P6,000,000· Percentage increase projected for next year sales = 20%· Net income this year amounts to P600,000· Retention ratio = 50%· Accounts payable = P1,100,000· Notes payable = P180,000· Accrued expenses = P500,000· Projected excess funds available next year is determined to be P200,000 Questions: 1. Determine the spontaneous liabilities increase. 2. How much is the increase in Retained Earnings? 3. How much is the total assets?
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here: Sales Costs Taxable income Taxes Net income Dividends Addition to retained earnings Current assets Fixed assets Total assets Assets Current assets Fixed assets INCOME STATEMENT Total assets $ 7,230,000 18,390,000 $ 1,149,982 1,724,853 Assets b-2. External financing needed c. Sustainable growth rate $ 25,620,000 a. Calculate the external funds needed for next year using the equation from the chapter. Note: Do not round intermediate calculations. External financing needed b-1. Prepare the firm's pro forma balance sheet for next year. Note: Do not round intermediate calculations. BALANCE SHEET Short-term debt Long-tern debt Common stock Accumulated retained earnings $ 30,500,000 26,077,300 $ 4,422,700 1,547,945 $ 2,874,755 Liabilities and Equity Total equity Total liabilities and…
Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's accounts receivable. Make the following assumptions: current year's sales are $55,750,000; current year's cost of goods sold is $25,350,000; sales are expected to rise by 25%, The firm's investment in accounts receivable in the current year is $12,600,000. The firm's marginal tax rate is 35%. What is the projection for next year's accounts receivable? $10,320,000 $11,345,000 O $15,750,000 $8,772,000
Using AFN formula in financial forecasting approach, given the following accounting information assuming that the firm's profit margin remains constant and the company is at full capacity. Sales = 6,000,000 Percentage increase projected for next year sales = 20% Net income this year = 600,000 Retention ratio = 50% Accounts Payabale = 1,100,000 Notes Payable = 180,000 Accrued expenses = 500,000 Projected excess funds available next year is = 200,000 Total assets amounted to?
Problem #1: Proforma Statements Prepare a common size income statement given the following information: Revenues = $100,000 COGS = $43,000 SG&A = $22,000 Interest Owed = $5,000 Tax Rate = 40% Problem #2: Proforma Statements Prepare a pro forma income statement from the data and common size income statement from #1, assuming that the sales will grow by 5% and all expenses but interest and taxes will scale with sales. 1, Use your plan of action to solve each problem, clearly outlining the procedures used, providing a concise explanation of each step, labeling relevant formulas, and showing worked out calculations and complete solutions. You may use an Excel spreadsheet or a calculator to help you perform the necessary calculations, but all corresponding work must be shown completely. 2. Answer all questions posed in the problem; if applicable, analyze and evaluate your results and provide a contextual explanation of the solutions you obtained. 3. Review your…
1. Given the most recent financial statements for FY2023. Sales for FY2024 are expected to grow by 10 percent. The following assumption must be held in the pro forma financial statements. The tax rate (percentage), the interest expense ($ amount), and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, all current asset accounts, Net PPE, intangibles, other assets, and accounts payable increase spontaneously with sales. Calculate the pro forma value for total assets for FY24 if the firm operates at full capacity and no new debt or equity is issued. (Enter percentages as decimals and round to 4 decimals) 2. Given the most recent financial statements for FY2023. Sales for FY2024 are expected to grow by 10 percent. The following assumption must be held in the pro forma financial statements. The tax rate (percentage), the interest expense ($ amount), and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, all…
A. Wally asks you to create an Income Statement for 2020 using the information below. 1. 2020 sales were 150% of last year’s sales2. Gross profit margin was 55%3. Operating profit margins were 15% 4. Interest expense fell to 7%, given a change in interest rates 5. The tax rate was 30% B. Based on the change in Income between 2020 and 2019, how would you say AndrewCo is doing?