With the given financial statements displayed in Excel : What is the five-year financial forecast for the
Fantastic news! We've Found the answer you've been seeking!
Question:
With the given financial statements displayed in Excel:
- What is the five-year financial forecast for the company (2011-2016)?
* I DO NOT need an explanation of methods, accounting info, etc.
* I NEED calculations in an Excel format to ensure mine is coming from the correct data. Thank you!
Link to the case study (copy and paste): https://www.imanet.org/-/media/219c07318fa3422eb0d7112a194642cb.ashx
Transcribed Image Text:
3 4 Sales 5 COGS 6 7 8 9 Depreciation Allocation 10 11 12 13 14 Operating Expenses 15 Owners/Mgt Compensation 16 CEO Bonus Compensation 17 Saleries & Wages 18 Professional Fees 19 Rent Allocation 20 Commissions 21 Bad Debts 22 Advertising & Promotion 23 Trade Shows 24 Research 25 Depreciation Allocation 26 Amortization - Purchase Debt 27 Interest 28 Other Expenses 29 30 31 32 Materials DL Rent Allocation Other Total COGS Gross Profit Total Operating Expenses Operating Profit 2005 2,050,742 693,945 207,823 18,374 19,110 95,798 1,035,050 1,015,692 133,000 20,327 139,523 45,131 20,793 71,815 14,000 94,304 29,021 14,224 3,901 12,600 42,310 210,169 851,118 164,574 2006 1,789,429 596, 194 185,736 26,921 12,434 62,723 884,008 905,421 151,000 4,270 29,395 99,177 24,447 154,430 0 74,302 25,184 24,582 2,814 12,600 19,517 264,125 885,843 19,578 2007 2,248,511 771,007 251,120 25,719 11,131 77,157 1,136,134 1,112,377 138,238 23,900 22,331 47,422 23,912 122,089 32,551 104,310 25,162 4,008 1,995 12,600 107,534 367,186 1,033,238 79,139 2008 2,600,000 910,000 296,000 26,000 17,770 100,230 1,350,000 1,250,000 150,000 32,500 24,500 10,000 24,000 143,770 26,140 120,000 26,000 15,000 3,230 12,600 117,630 219,630 925,000 325,000 2009 3,000,000 1,030,000 335,000 26,000 17,950 123,050 1,532,000 1,468,000 180,000 37,500 27,000 10,000 24,000 165,000 30,000 138,000 28,000 15,000 4,050 12,600 134,955 286,895 1,093,000 375,000 2010 3,500,000 1,195,000 390,000 26,000 19,800 146,200 1,777,000 1,723,000 220,000 45,000 29,700 10,000 24,000 191,345 34,790 160,000 30,000 15,000 4,200 12,600 156,548 339,817 1,273,000 450,000 2011 2012 2013 2014 3 4 Sales 5 COGS 6 7 8 9 Depreciation Allocation 10 11 12 13 14 Operating Expenses 15 Owners/Mgt Compensation 16 CEO Bonus Compensation 17 Saleries & Wages 18 Professional Fees 19 Rent Allocation 20 Commissions 21 Bad Debts 22 Advertising & Promotion 23 Trade Shows 24 Research 25 Depreciation Allocation 26 Amortization - Purchase Debt 27 Interest 28 Other Expenses 29 30 31 32 Materials DL Rent Allocation Other Total COGS Gross Profit Total Operating Expenses Operating Profit 2005 2,050,742 693,945 207,823 18,374 19,110 95,798 1,035,050 1,015,692 133,000 20,327 139,523 45,131 20,793 71,815 14,000 94,304 29,021 14,224 3,901 12,600 42,310 210,169 851,118 164,574 2006 1,789,429 596, 194 185,736 26,921 12,434 62,723 884,008 905,421 151,000 4,270 29,395 99,177 24,447 154,430 0 74,302 25,184 24,582 2,814 12,600 19,517 264,125 885,843 19,578 2007 2,248,511 771,007 251,120 25,719 11,131 77,157 1,136,134 1,112,377 138,238 23,900 22,331 47,422 23,912 122,089 32,551 104,310 25,162 4,008 1,995 12,600 107,534 367,186 1,033,238 79,139 2008 2,600,000 910,000 296,000 26,000 17,770 100,230 1,350,000 1,250,000 150,000 32,500 24,500 10,000 24,000 143,770 26,140 120,000 26,000 15,000 3,230 12,600 117,630 219,630 925,000 325,000 2009 3,000,000 1,030,000 335,000 26,000 17,950 123,050 1,532,000 1,468,000 180,000 37,500 27,000 10,000 24,000 165,000 30,000 138,000 28,000 15,000 4,050 12,600 134,955 286,895 1,093,000 375,000 2010 3,500,000 1,195,000 390,000 26,000 19,800 146,200 1,777,000 1,723,000 220,000 45,000 29,700 10,000 24,000 191,345 34,790 160,000 30,000 15,000 4,200 12,600 156,548 339,817 1,273,000 450,000 2011 2012 2013 2014
Expert Answer:
Answer rating: 100% (QA)
To create a fiveyear financial forecast for the company 20112016 based on the provided financial statements follow these steps 1 Income Statement Fore... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these finance questions
-
1. (2 Points) Suppose a firm has 10 workers, with a MPL of 50 and an APL of 75. If they hire an 11th worker (holding capital fixed), will the APL increase or decrease? 2. For this question, use the...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Write the answers in scientific notation. If K (2.410) (1.91011)
-
Mr. D. Duck, a sole trader has not maintained proper accounting records during the year. He provides you with bank statements that show payments to suppliers of 86,167. You determine that the opening...
-
The random variable A has pdf f(x) = e-x,x > 0. One observation is obtained on the random variable Y = X, and a test of H0 : =1 versus H1 : = 2 needs to be constructed. Find the UMP level = .10...
-
Air (Pr = 0.7, k = 0.026 W/m . K) at 200C flows across 2-cm-diameter tubes whose surface temperature is 50C with a Reynolds number of 8000. The Churchill and Bernstein convective heat transfer...
-
The 2015 annual report of The Procter & Gamble Company (P&G) TA 2, 3, 4 is available at www.pginvestor.com. After reviewing P&Gs annual report, respond to the following questions: a. What percentage...
-
The trial balance for Pioneer Advertising Agency is shown in Illustration 3-3, p. 104. In lieu of the adjusting entries shown in the text at October 31, assume the following adjustment data. 1....
-
In writing his name, Tomas is holding a pencil between his thumb and forefinger, while his younger sister Tia is scribbling with a pencil by holding the pencil with her palm and outer fingers pressed...
-
Determine the theoretical and actual material required to produce the part, shown in figure. Raw stock is supplied in 0.875 in. diameter. A lathe cutoff tool width is 0 125 in. A 0.015 in. stock...
-
Look up the three currencies; US Dollars, swedish Krona and the British pound in the foreign exchange section of a current issue of The Wall Street Journal. What is the current exchange rate between...
-
Listed below are what two researchers refer to as specific manifestations of organizational culture. Enterprises over a period of time illustrate or use these cultural factors to strengthen and...
-
Briefly explain the nature of transfer pricing or chargeout. How might transfer pricing or chargeout be used to control users of information systems services?
-
How is the increasing globalization of organizations impacting the study of applied organizational behavior?
-
Briefly explain the nature of ZBB. How might ZBB be used to control users of information systems services?
-
Some of the value principles of Levi Strauss are based on diversity , ethical practices, and empowerment . How does management expect them to be demonstrated on the job?
-
XaCo begins business in June and uses the periodic method. Its June merchandise purchases are $195,000 on account, F.O.B. shipping point. Merchandise that cost $3,000 is returned for credit. Goods...
-
Danielle has an insurance policy with a premium of $75 per month. In September she is in an accident and receives a bill worth $2990 for the repair of her own property. Her deductible is $250 and her...
-
A Fortune 500 company that we shall call Heavy is a manufacturer of machinery and engines. This company is headquartered in a small city in the midwestern region of the United States. This companys...
-
Cost allocation is arbitrary, so there is nothing gained by it. We should report only the costs that we know are direct. Do you agree? Why?
-
Kitchen Supply, Inc. (KSI), manufactures three types of flatware: institutional, standard, and silver. It applies all indirect costs according to a predetermined rate based on direct labor-hours. A...
-
A blank income statement for Wightmans Lumber is included in the Working Papers. 1. Use the following information to prepare Wightman Lumbers January income statement reporting contribution margin....
-
An income statement for Cheries Pizza is included in the Working Papers. 1. Use the following information to calculate the breakeven point in sales dollars and unit sales for July. The August...
-
Use the working papers and data from Work Together 15-2. Forms for completing this Work Together are provided in the Working Papers. Your instructor will guide you through the following examples. 1....
Study smarter with the SolutionInn App