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.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Martin Corporation’s expected sales revenue for the 4th quarter of 2023 is as follows: Oct…

A: The objective of the question is to calculate the expected cash collections for Martin Corporation…

Q: 1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019…

A: Income statement in simple term is an account which will give the information whether profit or loss…

Q: Forecast the next year Income Statement using the base year and growth rates.

A: Income Statement ItemBase YearGrowth RateForecast FormulaSales10020%Sales = Base Year Sales * (1 +…

Q: MBI Incorporated had sales of $35 million for fiscal 2022. The company's gross profit ratio for that…

A: Calculation: a. Percentage of gross profit is given which is 26%, therefore: Gross Profit = Sales…

Q: 1. Given the most recent financial statements for FY2023. Sales for FY2024 are expected to grow by…

A: The Internal Growth Rate (IGR) represents the maximum growth rate a company can achieve without…

Q: For the year ended December 31, 2019, Settles Inc. earned an ROI of 9.6%. Sales for the year were…

Q: Exhibit 2: Balanced scorecard for the time-guaranteed next-day B2C delivery market Year ending 31…

A: Growth percentage for any year is computed using following formula Growth % = (Current year…

Q: Use the formulas you learned about in the previous stage of the problem to answer the following…

A: Ratio analysis is a quantitative method to determine liquidity, operational efficiency, and…

Q: Suppose Naboo Manufacturing's sales increase 20% over the next year. Assuming that all asset…

A: Taxes Taxes are the amounts that defines the obligation of the taxpayers to pay tax over the income…

Q: on the pro forma income statement sales are expected to increase by 23%. If the net margin is…

A: Profit margin is calculated as (Net profit / Sales) * 100.However, in the present question, the net…

Q: A company expects sales of $420 million next year assuming a 20% increase from the previous year.…

A: Sales revenue refers to the revenue earned by the company during the period. Under accrual…

Q: Please I need

A: Step 1: Introduction to the Cost of Goods Sold Expense:The cost of goods sold expense represents the…

Q: Gross profit margin is 40%, tax rate is 30%: Sales year 1: 45000, year 2: 54000, year 3: 64800 (is…

A: Net income is referred to the income earned by an organization or an individual proprietor after…

Q: The table given below summarizes the 2022 income statement and end-year balance sheet of Drake's…

A: The ratio known as the debt-to-asset ratio establishes how much debt is used to fund a company's…

Q: Assuming costs vary with sales and a 20 percent increase in sales is projected, create the pro forma…

A: Due to our protocol only first three sub-parts are solved as there are four sub-parts. The plug…

Q: A company reports the following for the past year. Sales $ 11,680,000 Income 5,256,000 Average…

A: The ratio analysis helps to analyze the financial statements of the business. The return on…

Q: Use the table for the question(s) below FCF Forecast (5 million) Year Sales Growth vs. Prior Year…

A: The stock price at the start of year 1 can be calculated as follows: Calculate the terminal value…

Q: Problem #1: Proforma Statements Prepare a common size income statement given the following…

A: Hi studentSince there are multiple questions, we will answer only first question.Common size income…

Q: Your company forecasts that next year's sales will be $59.00 million, Cost of Goods Sold (COGS) will…

A: Accounts payables are calculated by multiplying days payables outstanding with the cost of goods…

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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

1 Lemon Auto Wholesalers had sales of $1,400,000 last year, and cost of goods sold represented 77 percent of sales. Selling and administrative expenses were 13 percent of sales. Depreciation expense was $10,000 and interest expense for the year was $9,000. The firm's tax rate is 30 percent. a. Compute earnings after taxes. Lemon Auto Wholesalers Income Statement $ $ $ 0 Anali 0 0 0 b-1. Assume the firm hires Ms. Carr an efficiency expert as a consultant. She suggests that by increasing selling and administrative
A) Obtain the EFN if the firm plans to have sales growth equal to 20% B) Use your fianncial model to estimate the internal growth rate
24. Following are a company's income statement at the end of the last year (year 0) and coming year (year 1). Each year, the company's accounts receivable need to be main- tained at 5% of sales. The company's inventory and accounts payable do not change. Capital expenditure in year 1 is $10,000. Year Sales Depreciation EBIT Taxes (a) What is the free cash flow in year 17 1 85,000 92,000 20,000 22,000 17,000 19,500 3,500 3,700 0 (b) The company's business is mature, so it is expected to generate the same amount of free cash flow every year forever. The firm-specific discount rate is 7%, and the risk-free rate is 2%. What is the enterprise value of the company? (c) The company has $150,000 in cash and $50,000 in debt. In addition, it has 7000 shares outstanding. What is the company's stock price per share?
1. Suppose you are given the following information for Bayside Bakery: sales = $30,000; addition to retained earnings = $4,221; dividends paid = $469; interest expense = $1,300; tax rate = 30 percent. What is the EBIT?
Your company has sales of $97,200 this year and cost of goods sold of $71,200. You forecast sales to increase to $113,100 next year. Using the percent of sales method, forecast next year's cost of goods sold.
Zeebadee Inc. wants to forecast free cash flow to equity (FCFE) using the percent-of- sales method. Prior year sales were $10,000. What is FCFE in Year 5 based on the information presented below? Sales growth Profit margin Net FCInv (% of Sales) WCInv (% of Sales) DR $2,335.93 $1,687.06 $1,008.00 $1,557.29 Year 1 Year 4 Year 2 Year 3 14.00% 12.00% 10.00% 10.00% 9.00% 10.00% 12.00% 12.00% 8.00% 8.00% 8.00% 6.00% 3.00% 3.00% 2.00% 3.00% 40.00% 40.00% 40.00% 40.00% Year 5 5.00% 12.00% 3.00% 1.00% 40.00% 4
Vikings Inc., is developing a pro forma income statement for the coming year. The chief financial officer estimates that sales will be $150,000,000. If gross profits are historically 36% of sales, what is the expected cost of goods sold (in dollars)? a) $36,000,000 b) $54,000,000 c) $64,000,000 d) $96,000,000 NOTE: In your Excel spreadsheet, all calculations must be included
Use the table for the question(s) below. FCF Forecast ($ million) Year Sales 1 270 12.5% 32.40 Less: Income Tax (37%) (6.48) Less Increase in NWC (12% of Change in Sales) 3,60 Free Cash Flow 22.32 Growth versus Prior Year EBIT (10% of Sales) 0 240 OA. $4.27 OB. $7.47 OC. $12.8 OD. $5.12 2 290 7.4% 34.80 (6.96) 2.40 25.44 ACCE 3 310 6.9% 37.20 (7.44) 2.40 27.36 Banco Industries expect sales to grow at a rapid rate over the next 3 years, but settle to an industry growth rate of 4% in year 4. The spreadsheet above shows a simplified pro forma for Banco Industries. Banco industries has a weighted average cost of capital of 10%, $30 million in cash, $60 million in debt, and 18 million shares outstanding. If Banco Industries can reduce its operating expenses so that EBIT becomes 12% of sales, by how much will its stock price increase? 4 325.5 5.0% 39.06 (7.81) 1.86 29.388
The following table shows CLV for A company. What is the CLV of the first year (please round it up)? Profit per Annual Customer Annual Year CustomerRetention Accounts Discount Discount ($) Probability RemainingRate 0 1 50 2 70 3 ↑ 75 41 42 43 44 45 90% 87% 85% 100 90 78.3 66.5 0.1 0.1 Cumulative Discounted Cash Flow ($)0 0.1 Factor 0.91 0.83 0.75
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
The S&H construction company expects to have total sales next year totaling $15,300. In addition, the firm pays taxes at 35 percent and will owe $280,000 in interest expense. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 57 percent of sales and operating expenses will total 32 percent. What is your estimate of firm’s net income after taxes for the coming year? Complete the forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating income Interest expenses Earnings before taxes Taxes Net income
Assume that in 20X2, sales increase by 10 percent and cost of goods sold increases by 20 percent. The firm is able to keep all other expenses the same. Assume a tax rate of 30 percent on income before taxes. What is income after taxes and the profit margin for 20X2?

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS