Make a financial spreadsheet of given below. Your supervisor in the finance department at a Technology Company
Fantastic news! We've Found the answer you've been seeking!
Question:
Make a financial spreadsheet of given below.
Transcribed Image Text:
Your supervisor in the finance department at a Technology Company has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses, operating income, income taxes, and net income for the next eight years Students are given the information for Years 1 and 2 as an example and to help with this assignment. Students need to make projections for Years 3 to Year 3 by following the instructions below. How to do it . Given the values for Year 1 and Year 2, compute the financial projects for Year 3 to Year 8. • The areas you need to add formulas in are indicated in YELLOW highlight. • You can use Year 1 and Year 2 values as an example of how your calculations should compute. 1. Download the example files to help you start, and the solution pdf file below. 2. In cells C6-16,using Excel formulas, compute Gross Margins for the year which is Sales - Cost of Goods for the year. 3. In cells C8-18, using Excel formulas, compute Advertising which is $1250 +8% of Sales 4. In cells D10-110, using Excel formulas, compute Rent which is a 6.5% increase per year based on the previous years Sales 5. In cells D11-111, using Excel formulas, compute Salaries for the year which are 12% of Sales for that year, 6. In cells D12-112, using Excel formulas, compute Shipping for the year which are 3.6% of Sales for that year.. 7. In cells D13-113, using Excel formulas, compute Supplies which is 1.2 % of Sales for that year. 8. In cells D15-115, using Excel formulas, compute Total Expenses which is the sum of all Expenses (Row 8-Row 14) for each year. 9. In cells D17-117, using Excel formulas, compute Operating Income which is Gross Margins-Total Expenses each year. 10. In cells D19-119, using Excel formulas, compute Net Income which is the Operating Income-Income Tax 11. Center you tities by using merge-and-center in Excel 12. Create a chart of Sales 13. Create a second chart of Operating versus Net Income 14. Improve your formatting to look nice/similar to the example solution file below. Please be sure to format the spreadsheet and the graphs to look nice. Your supervisor in the finance department at a Technology Company has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses, operating income, income taxes, and net income for the next eight years Students are given the information for Years 1 and 2 as an example and to help with this assignment. Students need to make projections for Years 3 to Year 3 by following the instructions below. How to do it . Given the values for Year 1 and Year 2, compute the financial projects for Year 3 to Year 8. • The areas you need to add formulas in are indicated in YELLOW highlight. • You can use Year 1 and Year 2 values as an example of how your calculations should compute. 1. Download the example files to help you start, and the solution pdf file below. 2. In cells C6-16,using Excel formulas, compute Gross Margins for the year which is Sales - Cost of Goods for the year. 3. In cells C8-18, using Excel formulas, compute Advertising which is $1250 +8% of Sales 4. In cells D10-110, using Excel formulas, compute Rent which is a 6.5% increase per year based on the previous years Sales 5. In cells D11-111, using Excel formulas, compute Salaries for the year which are 12% of Sales for that year, 6. In cells D12-112, using Excel formulas, compute Shipping for the year which are 3.6% of Sales for that year.. 7. In cells D13-113, using Excel formulas, compute Supplies which is 1.2 % of Sales for that year. 8. In cells D15-115, using Excel formulas, compute Total Expenses which is the sum of all Expenses (Row 8-Row 14) for each year. 9. In cells D17-117, using Excel formulas, compute Operating Income which is Gross Margins-Total Expenses each year. 10. In cells D19-119, using Excel formulas, compute Net Income which is the Operating Income-Income Tax 11. Center you tities by using merge-and-center in Excel 12. Create a chart of Sales 13. Create a second chart of Operating versus Net Income 14. Improve your formatting to look nice/similar to the example solution file below. Please be sure to format the spreadsheet and the graphs to look nice.
Expert Answer:
Answer rating: 100% (QA)
Financial Projections Spreadsheet Instructions Download the example files to help you start In cells C616 using Excel formulas compute Gross Margins f... View the full answer
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these accounting questions
-
Thomas Manufacturing includes the following accounting records: Dec. 31, 2016 31-Dec-15 Work in Process Inventory $15,000 $12,000 Finished Goods Inventory $45,000 $51,000 Materials...
-
Your supervisor in the finance department at Adaptive Solutions Online has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses,...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Two independent situations follow: 1. Ready Car Rental leased a car to Culver Company for three months. Terms of the lease agreement call for monthly payments of $885, beginning on May 21, 2024....
-
List the errors you find in the following partial balance sheet: Burnt Red Company Balance Sheet December 31, 20Y2 Assets Total current assets $350,000 Replacement Accumulated Book Depreciation Value...
-
At Samanthas Super Store the customer service area processes customer returns, answers customer questions and provides information, addresses customer complaints, and sells gift certificates. The...
-
Which statement is false? a. SAS No. 99 does not mention forensic accounting. b. SAS No. 99 does not require auditors to make inquiries of "others" as opposed to management. c. Many of the companies...
-
Austin, Inc., acquired 10 percent of McKenzie Corporation on January 1, 2014, for $210,000 although McKenzies book value on that date was $1,700,000. McKenzie held land that was undervalued by...
-
2. KAYA MO BA Corporation recently installed an activity-based relational data base. Using the information contained in the activity relational table, the following pool rates were computed: Php 200...
-
Damon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior...
-
0.9 A jet of water, issuing from a sharp-edged vertical orifice under a constant head of 10.0 cm, at a certain point, has the horizontal and vertical co-ordinates measured from the vena-contracta as...
-
Watch the two videos from Shakespears in Love https://youtu.be/WydbcNQpN7Q At the beginning of the movie we see Mr. Henslow being dragged away by Mr. Fennyman and his men over a debt. Without...
-
What revenue categories do you think needs to be added to the master chart of accounts to reflect the new economy?
-
Watch the video on the investigation of the homicide to complete the following sections on the case: 1. Write the background information on your case. Explain what happened? Make sure to identify the...
-
On June 1 of the current year, Pamela Schatz established a business to manage rental property. She completed the following transactions during June: Opened a business bank account with a deposit of $...
-
Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule receipt. + Beginning...
-
there are basically 2 types of employment in government. You can "serve at the pleasure of..." (ie...political appointee) or be a union employee (ie...civil service). In my career I have served as...
-
A bar of length = 1 has one fixed and one free end and stiffness function c(x) = 1 - x. Find the displacement when subjected to a unit force. Pay careful attention to the boundary condition at the...
-
Is financial management important for public service organizations? If so, why?
-
Why is the relevant range the key to the difference between variable and marginal costs?
-
What is the organizations mission and why is it important?
-
1. ETHICS Suppose you were on a state supreme court and faced with a restaurant- choking case. Should you require restaurant employees to know and employ the Heimlich maneuver to assist a choking...
-
Question: When Hiller Systems, Inc., was performing a safety inspection on board the M/V Cape Diamond, an ocean-going vessel, an accident killed two men. The Occupational Safety and Health...
-
2. YOU BE THE JUDGE WRITING PROBLEM An off-duty, out-of-uniform police officer and his son purchased some food from a 7-Eleven store and were still in the parking lot when a carload of teenagers...
Study smarter with the SolutionInn App