Based on the following information, what is the year 1 income statement, Balance sheet end of year
Fantastic news! We've Found the answer you've been seeking!
Question:
Based on the following information, what is the year 1 income statement, Balance sheet end of year 1, Year 1 cash flow, and must sell in order to sell to break even. ?I have uploaded the template to follow?
Transcribed Image Text:
Transaction # 9 # of Tour Groups Forecasted to Sell 9 # of Students Per Tour Group Total Number of Students Expected to Travel Total Revenue Total Revenue Per Tour Group Total Revenue Per Student Revenue 9 Tour Revenue 10 Trip Cancellation Insurance 11 Trip Cancellation Penalty Total Revenue 3 14 15 13 Cost of Goods/Services Sold 12 Tour COGS 10 Trip Cancellation Insurance COGS Total COGS GROSS MARGIN Operating Expenses Facility Rent Salaries Benefits Sales Commission Expenses Marketing Collateral Usage Marketing & Advertising Expense 17 6 Computer Equipment Rent/Lease 7 Other Operating Expense Depreciation & Amortization Total Operating Expenses Operating Income (Before Tax) EBITDA 8 Other: Interest (Income)/Expense Net Income-S Corporation Year 1 Income Statement CAPEX Investments 4 Minivan 5 Office Furniture 7 Promotional Video Total CAPEX Investments 8/31/94-8/31/95 $ $ $ $ $ $ $ $ $ $ 100.00 42.00 4,200.00 2,895,000 28,950 689 2,835,000.00 50,000.00 10,000.00 2,895,000.00 2,126,250.00 .75 x 2,895,000, 75% of total rev 20,000.00 2,146,250.00 748,750.00 24,000.00 325,000.00 65,000.00 141,750.00 20,000.00 85,000.00 6,000.00 x 40,000.00 x? Or 20,000 15,357.14 722,107.14 26,642.86 42,000.00 Fixed vs variable costs 25,000.00 1,642.86 20,000 35,000 27,000 82,000.00 Useful Life 7.0 10.0 3.0 Annual Depr & Amort 2,857 3,500 9,000 15,357 $ Transaction # 9 # of Tour Groups Forecasted to Sell 9 # of Students Per Tour Group Total Number of Students Expected to Travel Total Revenue Total Revenue Per Tour Group Total Revenue Per Student Revenue 9 Tour Revenue 10 Trip Cancellation Insurance 11 Trip Cancellation Penalty Total Revenue 3 14 15 13 Cost of Goods/Services Sold 12 Tour COGS 10 Trip Cancellation Insurance COGS Total COGS GROSS MARGIN Operating Expenses Facility Rent Salaries Benefits Sales Commission Expenses Marketing Collateral Usage Marketing & Advertising Expense 17 6 Computer Equipment Rent/Lease 7 Other Operating Expense Depreciation & Amortization Total Operating Expenses Operating Income (Before Tax) EBITDA 8 Other: Interest (Income)/Expense Net Income-S Corporation Year 1 Income Statement CAPEX Investments 4 Minivan 5 Office Furniture 7 Promotional Video Total CAPEX Investments 8/31/94-8/31/95 $ $ $ $ $ $ $ $ $ $ 100.00 42.00 4,200.00 2,895,000 28,950 689 2,835,000.00 50,000.00 10,000.00 2,895,000.00 2,126,250.00 .75 x 2,895,000, 75% of total rev 20,000.00 2,146,250.00 748,750.00 24,000.00 325,000.00 65,000.00 141,750.00 20,000.00 85,000.00 6,000.00 x 40,000.00 x? Or 20,000 15,357.14 722,107.14 26,642.86 42,000.00 Fixed vs variable costs 25,000.00 1,642.86 20,000 35,000 27,000 82,000.00 Useful Life 7.0 10.0 3.0 Annual Depr & Amort 2,857 3,500 9,000 15,357 $
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided the Year 1 Income Statement for Cookie Creations for the period ending August 31 1995 is as follows Year 1 Income Statement Period 8319483195 Total Revenue 283500000 ... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these finance questions
-
31 / 124 A call to rethink ethics and equity in computing education. T HIS COLUMN AIMS to build on and extend the field's under- standings of the nature of ethics and equity in comput- ing....
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Simplify the following 1. cos(-3x) cos(-x) - cos(-3x) sin(-x) 2. 2 cos(-)-1 5 3. sin12- sin8
-
There is a bond on the spot-market. Price is 87.63 USD. Risk-free interest rate is 1.22%. The forward-price is 102.78 USD. Is there any arbitrage possibility if time to maturity is 9 months?
-
Emilio and Rene Santos own Club Fandango. From its inception, Club Fandango has sold merchandise on either a cash or credit basis, but no credit cards have been accepted. During the past several...
-
Find the surface area of the helicoid r(r, ) = (r cos )i + (r sin )j + k, 0 2, 0 r 1, in the accompanying figure. (1, 0, 2TT) (1, 0, 0) X N 2TT
-
The Glendora Company has 200,000 shares of cumulative, five percent, \(\$ 100\) par value preferred stock outstanding. Last year the company failed to pay its regular dividend, but the board of...
-
A table saw costs $175 at a local store. You may either pay cash for it or pay $35 now and $12.64 a month for 12 months beginning 30 days hence. If you choose the time payment plan, what nominal...
-
REQUIRED Prepare the production plan for each month of the quarter ending 31 March 2024. (6 marks) INFORMATION The information given below was supplied by Philips Enterprises: The expected sales for...
-
The idealized cross-section of a two-cell thin-walled wing box is shown below with the data in Table 22.7. If the wing box supports a load of 44,500 N acting along web 25, calculate the shear flow...
-
Which of the folowing are effective sourcing performance metrics? (Select the three answers that apply) Response time Supplier fill rate Supplier total years in operation Delivery performance
-
Suppose that lim f(x) = 0, lim g(x) = 0, lim h(x) = 1, lim p(x) = oo, and lim q(x) = 00. I a DI Evaluate each of the following limits. (a) lim[f(x)p(x)] = Ha (b) lim[h(x)p(x)]= Ha (c) lim[p(x)q(x)] =...
-
Consider the code fragment, i-1 while (i < N) do { print "Ramadan Kareem" i-2*1+1 } Let H(N) be the number of times "Ramadan Kareem!" is printed as a function of constant N. (a) Derive H(N). (b)...
-
What are properties and application for lamellar pearlite, globular pearlite and beaded pearlite?
-
What major changes in healthcare have warranted the need for increased marketing strategies?
-
dy Find by implicit differentiation. dy dx = dx x7xy5 + y = 1
-
Why are future value factor tables not as common as they once were?
-
Discuss the information available from the following techniques in the analysis of inorganic pigments used in antique oil paintings: (i) Powder X-ray diffraction, (ii) Infrared and Raman...
-
Compton Information Services, Inc., has two service departments: human resources and billing. Compton's operating departments, organized according to the special industry each department serves, are...
-
Reardan Company established a predetermined fixed overhead cost rate of $29 per unit of product. The company planned to make 7,000 units of product but actually produced only 6,500 units. Actual...
-
According to its original plan, Topeka Consulting Services Company plans to charge its customers for service at $120 per hour in 2018. The company president expects consulting services provided to...
-
It frequently happens that a table with data needs to be restructured before the data can be analyzed using standard statistical software. As an example, consider the test scores in Table 1. 3 of 5...
-
Hospitality Inc. (HI) is a holding company that has wholly owned interests in the travel and entertainment industry. HI is listed on the Toronto Stock Exchange and is subject to the reporting...
-
Create a similar barplot as in Figure 1. 5, but now plot the corresponding proportions of males and females in each of the three situation categories. That is, the heights of the bars should sum up...
Study smarter with the SolutionInn App