Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000

Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter4: Preparing And Using Financial Statements

Section: Chapter Questions

Problem 1bM

See similar textbooks

Related questions

Q: Sales forecasts. For the prior three years, sales for California Cement Company have been…

A: A percentage that represents the increase in a particular variable at a particular time interval is…

Q: Sammy Corporation reported net sales of P300,000, P330,000, and P360,000 in the years, 2010, 2011,…

A: Horizontal analysis: Horizontal analysis can be defined as the analysis used to identify the change…

Q: The financial statements for the year ended June 30, 2011, are given below for Morgan Construction…

A: Financial statement Financial statements refer to those statements which contain all the financial…

Q: formation related to financial projections for next year is as follows: ) Projected sales are…

A: Financial statement: Financial statements are organized summaries of detailed information about the…

Q: Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the…

A: In finance we often use the concept of moving averages to predict and forecast sales of future…

Q: How much is the increase in retained earnings that will contribute to cover the increase in asset?

A: In this case, total assets, net profit and spontaneous liabilities all would increase by the…

Q: A company's sales in 2010 were P300,000 and in 2011 were P351,000. Using 2010 as the base year, the…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Suppose that TV Industries, Inc. currently has the balance sheet shown as follows, and that sales…

A: The question is based on the calculation of additional fund need to fulfill the requirement to…

Q: Bulldogs Inc. recently reported net income of P5,000,0000. The firm has P40,000,000 total assets.…

A: The increase in retained earnings is calculated as change in forecasted net income multiplied by the…

Q: The net income is RO 20 million. Last year's sales were RO 180 million. The total assets represent…

A: External Financing needed = (Assets/Sales) x (Δ Sales) - (Spon lIab/Sales ) x (Δ Sales) - (PM x FS)…

Q: Consider the following information that you propose to use to obtain an estimate of year 2004 EPS…

A: The investors use the information displayed by the company in their financial statement that is the…

Q: XYZ Co. wants to know if its profitability performance has increased from 2009 to 2010. The company…

A: Ratio analysis is a method of measuring the financial position of the organization with different…

Q: A company's sales in 2010 were P300,000 and in 2011 were P351,000. Using 2010 as the base year, the…

A: The sales trend percent for 2011 is: 117% Calculation of sales trend percent for 2011 is:…

Q: Sammy Corporation reported net sales of P300,000, P330,000, and P360,000 in the years, 2010, 2011,…

A: Given, Net sale of 2010 = P 300,000 Net sales of 2011 = P 330,000 Net sales of 2012 = P 360,000 Base…

Q: If we expect sales to increase by 20% next year what should be the new level of net income? (…

A: As per the honor code, we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit…

Q: Jasper Jewelry has $150 million in sales. The company expects that its sales will increase 5% this…

A: Sales =$150 Million Sale increase percentage =5% Inventories = $11 + 0.07(Sales)

Q: Salae foracaete For the nrior thrag years, sales for California Cement Company have been $20,045,000…

A: Sales growth rate for 2012 = (sales 2012 - sales 2011) /sales 2011

Q: What should be the projected sales for year 2017? Show your solution.

A: Information provided: Sales for the years: 2013-2016 = 7M, 8M, 9M, 12M Projected rate = 10%

Q: 1. Company Z has the following data: • Sales 2015 is 500M • Sales growth rate: 9% in 2016 but will…

A: Note: This post has two distinct questions. Q1 has been answered below.

Q: Austin Grocers recently reported the following 2018income statement (in millions of dollars): For…

A: The Growth rate of the dividend can be found by deducting the dividend as at the end of the year…

Q: Using the data in the following table for a number of firms in the same industry, do the following:…

A: Answer 1: Total Asset Turnover =Total SalesNet Assets Net Profit Margin = Net Income After taxNet…

Q: A company's sales in 2010 were P300,000 and in 2011 were P351,000. Using 2010 as the base year, the…

A: Note: Since you have posted multiple questions, we will solve the first question. Please submit a…

Q: ecently reported net income of P5,000,0000. The firm has P40,000,000 total assets. Next year, Inc.…

A: Out of the net income some part is paid as dividend and some part is retained with firm for future…

Q: Use the following information from Salalah Packaging Company to calculate Average Annual Growth Rate…

A: “Since you have posted multiple questions, we will solve first question for you. If you want any…

Q: If a company had sales of $2,587,643 in 2008 and sales of $3,213,456 in2013, by what percentage did…

Q: Jace Furnishings has $325 million in sales. The company expects that its sales will increase 8% this…

A: Current sale =$325 Million Growth rate =8% Expected Sale = Sale *(1+growth rate) = 325*(1+0.08)…

Q: Antivirus Inc. expects its sales next year to be $3,100,000. Inventory and accounts receivable will…

A: Given, Expected sales next year = $3,100,000 Increase in inventory and accounts = $540,000 Profit…

Q: Pro forma income statement. Given the income statement in the popup window, E, for California Cement…

A: A component of the financial statement of a company that provides information regarding the profit…

Q: A company’s sales in 2010 were P300,000 and in 2011 were P351,000. Using 2010 as the base year, the…

A: PLEASE LIKE THE ANSWER Answer: 17% Sales trend Formula = (sales of 2011 - sales of 2010/ sales…

Q: The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The current…

A: Calculate the external funds needed as follows:

Q: Using the AFN formula in financial forecasting approach, Determine the following for Piano Co. given…

A: Additional fund Needed (AFN) is also known as external financing needed. It is the amount of funds…

Q: Stevens Textiles’s 2010 financial statements are shown below:…

A: 1. Income Statement Particulars Dec 2010 ($) Dec 2011 ($) Sales (15% increase) 36,000 41,400…

Q: The Manning Company has financial statements as shown next, which are representative of the…

A: Income Statement The purpose of preparing the income statement is to know the net income which are…

Q: Sales forecasts. For the prior three years, sales for National Beverage Company have been…

A: Sales growth rate for 2012 = (sales 2012 - sales 2011) /sales 2011

Q: Romblon Company reported the following sales: P500,000 (2018); P520,000 (2019) and P551,200 (2020).…

A: Sales Year P500,000 (2018) P520,000 (2019) P551,200 (2020)

Q: A company's sales in 2010 were P300,00O and in 2011 were P351,000. Using 2010 as the base year, the…

A: "Since you have asked multiple questions, we will solve the first question for you". If you want any…

Q: Using AFN formula in financial forecasting approach, given the following accounting information…

A: AFN or Additional fund needed is also referred to as the external financing needed. It is that…

Q: This year, ABC expects sales of $137,328,000 and a gross profit margin of 16 percent this year,…

A: given, sales = $137,328,000 gross profit margin = 16% COGS = SALES x (1- GROSS PROFIT MARGIN) COGS =…

Q: The S&H construction company expects to have total sales next year totaling $15,300. In addition,…

A: Sales = 15,300 Tax Rate = 35% Interest Expense = 280,000 Cost of goods sold = 57% of Sales Operating…

Q: Last year, Jumpin' Trampolines (JT) had a quick ratio of 1.0, a current ratio of 1.8, an inventory…

A: Ratio analysis is the financial analysis that is used by corporations to estimate and determine…

Q: Net Income for Company A is $200,000 in 2014, $300,000 in 2015, $400,000 in 2016, $500,000 in 2017,…

A: The dividend discount model (DDM) is a quantitative method used for predicting the worth} of a…

Q: 1. Company Z has the following data: • Sales 2015 is 500M • Sales growth rate: 9% in 2016 but will…

A: As per the honor code, we’ll answer only one question at a time, we have answered the first question…

Q: The Manning Company has financial statements as shown next, which are representative of the…

A: The following computations are done to check for external financing needs.

Q: Net Income for Company A is $200,000 in 2014, $300,000 in 2015, $400,000 in 2016, $500,000 in 2017,…

A: In this we have to calculate present value of future value of cash flow.

Q: What is the return on assets? Return on Stockholders' equity? If the firm has a asset turnover ratio…

A: Ratio analysis: The analysis of a company using the financial ratios and comparing its trends and…

Q: The sales data for Lonestar Sports Apparel Company for the last 12 years are as follows: 2001…

A: Compound Growth rates are used to compare investment returns to determine which investment has…

Question

Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach?
Year:
2009
2010
2011
2012
2013
Sales
$1,500,000
$1,750,000
$1,400,000
$2,000,000
$1,600,000

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

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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

Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,530,000 $1,720,000 $1,560,000 $2,100,000 $1,850,000 What would be the forecast for next year’s sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar.
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $3,100,000 $3,350,000 $3,000,000 $3,600,000 $3,200,000 What would be the forecast for next year’s sales using the naïve approach?
Romblon Company reported the following sales: P500,000 (2018); P520,000 (2019) and P551,200 (2020). Using the average growth rate method, the forecasted sales for 2021 and 2022 are" "P562,400 and P573,600" "P576,800 and P602,400" "P578,760 and P607,698" "P595,296 and P654,826"
Consider the following information that you propose to use to obtain an estimate of year 2004 EPS for the MacLog Company. Estimated Year 2019 Year 2020 GDP 11,000 Billion GDP growth 3.5% Sales per share $800 Operating profit margin 12% Depreciation/Fixed Assets 14% Fixed asset turnover 2 Interest rate 3.5% Total asset turnover 0.7 Debt/Total assets 45% Tax rate 36% In addition, a regression analysis indicates the following relationship between growth in sales per share for MacLog, and GDP growth is %Δ Sales per share = 0.015 + 0.75(%Δ GDP) Refer to Exhibit 9.6. Calculate the firm's level of Total Assets per share for the year 2020. a. $1,385.77 b. $1,113.58 c. $1,050.65 d. $1,065.67 e. $1,190.06
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?
Returns for the Alcoff Company over the last 3 years are shown below. What's the standard deviation of the firm's returns? Year Return2010 21.00%2009 −12.50%2008 25.00%
on the pro forma income statement sales are expected to increase by 23%. If the net margin is expected to increase by 18% and net profit last year was 100 million, what is the net profit projected to be? A) 118 million. B)123 million. C )158 million D) 141 million
A company's annual profits have a trend line given by Y = 20,000t – 10,000, where Y is the trend and t is the year with t = 0 in 2012. What is the forecasted profit for the year 2021 using an additive model if the seasonal variation for that year is –30,000?
Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first quarter of 2022.
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 Spontaneous liabilities increase is?
he following data represents the annual sales of a Digitech Automation products SAOG. Year 2014 2015 2016 2017 2018 Sales (in Millions) OMR 380 440 520 396 514 Use method of least squares to calculate the trend values and the forecast for the future period. Which of the following is the annual sales forecast for the year 2019 using least squares method? a. 539.6 Million OMR b. 584.4 Million OMR c. 606.8 Million OMR d. 562 Million OMR