The Income statement and balance sheet for Central Perks Inc. are provided here. Note that firm's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Income statement and balance sheet for Central Perks Inc. are provided here. Note that firm's capital expenditures are expected to rise by $50,000 in the new year. This will lead to an increase of $5,000 in depreciation expense from 2019. Sales next year should be $4,407,500, and the dividend payment to common stockholders will equal the dividend payment in 2019. Cost of Goods Sold, S,G&A Expense, Interest Expense, Accounts Receivable, Inventory, Accounts Payable, and Other Current Liabilities will vary with sales. Cash, Notes Payable, Long-Term Debt, and Common Stock will remain the same as in 2019. 1. Using the information given and percentage of sales analysis techniques where appropriate, prepare a pro forma income statement and balance sheet for the next year. Since both 2018 and 2019 financial statements are given, use the average percentage of sales from both years. Calculate the amount of financing needed for the balance sheet. 2. Create a chart of sales by year for all years, including your pro forma estimate. 3. Add a trend line. 4. Create a scatter plot of sales vs. cogs. Add a trend line. 5. Regress cogs against sales (do not include the 2010 estimates). 6. Using your sales trendline and annual sales data forecast the sales level in the next 3 years (3 years after the year with 4.3M in sales). Forecast using the trend line as well as at least one of the following: trend, linest, regression. The Income statement and balance sheet for Central Perks Inc. are provided here. Note that firm's capital expenditures are expected to rise by $50,000 in the new year. This will lead to an increase of $5,000 in depreciation expense from 2019. Sales next year should be $4,407,500, and the dividend payment to common stockholders will equal the dividend payment in 2019. Cost of Goods Sold, S,G&A Expense, Interest Expense, Accounts Receivable, Inventory, Accounts Payable, and Other Current Liabilities will vary with sales. Cash, Notes Payable, Long-Term Debt, and Common Stock will remain the same as in 2019. 1. Using the information given and percentage of sales analysis techniques where appropriate, prepare a pro forma income statement and balance sheet for the next year. Since both 2018 and 2019 financial statements are given, use the average percentage of sales from both years. Calculate the amount of financing needed for the balance sheet. 2. Create a chart of sales by year for all years, including your pro forma estimate. 3. Add a trend line. 4. Create a scatter plot of sales vs. cogs. Add a trend line. 5. Regress cogs against sales (do not include the 2010 estimates). 6. Using your sales trendline and annual sales data forecast the sales level in the next 3 years (3 years after the year with 4.3M in sales). Forecast using the trend line as well as at least one of the following: trend, linest, regression.
Expert Answer:
Answer rating: 100% (QA)
To prepare a pro forma income statement and balance sheet for the next year well use the average percentage of sales from both 2018 and 2019 Lets calculate the amounts based on the given information 1 ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
The Stair Company sells computer parts through a retail store that it operates. The firms comparative income statement and balance sheet for the years 2019 and 2018 follow: INSTRUCTIONS 1. Prepare...
-
You are a CPA student working in the accounting department of Reynolds Liquor Distributors Ltd. (RLDL) for the year ended December 31, 2019. Your role requires you to prepare and analyze the annual...
-
Fox rented a house from Chiodini, but before he moved in, he noticed exposed electrical wiring in the basement, so he refused to move in. City inspectors confirmed a code violation and Chiodini fixed...
-
A cylinder fitted with a piston restrained by a linear spring contains 2 lbm of R-22 at 220 F, 125 lbf/in 2. The system is shown in Fig. P6.72 where the spring constant is 285lbf/in, and the piston...
-
On January 1, 2018, Outreach Incorporated sold services to a Canadian supply company and accepted a three-year note in the amount of 11,000 Canadian dollars. Assume that exchange rates between the...
-
Continuing the previous problem, how much of your first payment will be interest? a. $105.44 b. $116.41 c. $128.90 d. $130.21
-
Rouse Company, a real estate developer, is well known as one of the few U.S. companies to have reported the current value of property and equipment in its financial statements. As mentioned in the...
-
Find the average value of f(x,y) = sin (x + y) over a. the rectangle 0 x/3, 0 5/3 b. the rectangle 0 x2/3, 0s7/6 a. The average value of f is 0 0. (Type an exact answer, using it as needed.) b. The...
-
A mechanical engineer at Anode Metals is considering five equivalent projects, some of which have different life expectations. Salvage value is nil for all alternatives. Assuming that the companys...
-
Consider a flat term structure of interest rates (2% expressed in continuous compounded for every term) and the following bonds: 1st 2nd 3rd 4th 100; 100; 100; 400; Maturity 0; 1; 102; 2; 12; 0; 2;...
-
What is risk? How does management generally perceive the dimensions of risk?
-
How would business risk analysis have helped the auditors in the Lincoln Savings & Loan audit?
-
Does the auditors responsibility for detecting errors differ from the auditors responsibility for detecting fraud? Explain.
-
Why might a management action to do nothing in response to a new product introduction by a competitor be considered risky?
-
What are the advantages of PPS sampling over other statistical methods?
-
Please answer with detailed explanation else downvote. . Empresas ABC has an account receivable in Chilean pesos. The increase in the value of Chilean pesos at the time of collecting the account...
-
Problem 2. (0.6 points, 0.2 points for each question) (a) A company turns its inventory 2 times a month. Its months-of-supply = Its days-of-supply = Please show your analysis below: _months. days. (1...
-
The Coca-Cola Company (Coca-Cola), like PepsiCo, manufactures and markets a variety of beverages. Exhibit 3.18 presents a statement of cash flows for Coca-Cola for three years. Exhibit 3.18 The...
-
Exhibit 8.29 presents the separate financial statements at December 31, 2015, of Prestige Resorts and its 80%-owned subsidiary Booking, Inc. Two years earlier on January 1, 2014, Prestige acquired...
-
Prime Contractors (Prime) is a privately owned company that contracts with the U.S. government to provide various services under multiyear (usually five-year) contracts. Its principal services are as...
-
Two customers stay in identical budget hotel rooms in the same hotel, on the same night; one has paid 29, whilst the other has paid 59. Using revenue management explain this situation.
-
On a specific flight there are 240 seats available, at a maximum price of 200 per seat. However only 180 seats are sold, with an average achieved ticket price of 110. Calculate the yield management %...
-
Define the two strategic drivers of revenue management.
Study smarter with the SolutionInn App