create a business analysis tool to calculate a business's potential profit using multiple variables , writing homework help

User Generated

Qzntvp27

Business Finance

Description

1. Students have LOTS of latitude in this assignment. Students may build an analysis too similar in

content and/or format to the 'Buggy Supplies 'R Us' example below, or build an analysis tool for

any business opportunity using their own content and format..

2. The analysis tool must accommodate AT LEAST 6 revenue streams and AT LEAST 6 types of

expenses. Some of the revenue streams and some of the expenses must allow for the input of

two variables. (e.g., quantity sold * selling price –or- number of employees * annual rate)

3. Provide subtotals for each logical block of information

4. Format the analysis so there is a nice flow to it and it is easy to comprehend. Use grid lines and

color to clarify and emphasize.

5. Provide a 'BOTTOM LINE' block that summarizes the projections of all anticipated revenues and

expenses

6. Be sure to validate the accuracy of ALL calculated values!

7. In a cell adjacent to 'the bottom line' section, develop an 'IF' statement that displays an

appropriate message if the analysis calculates to a net loss

8. Finishing touches –and suggestions

a. Ensure consistency in the presence (or absence) of 'cents'

b. Ensure consistency in the use (or non-use) of the ' sign in cells depicting currency

c. Suggestion: Avoid the use of dark background colors as they will obscure the text in

those cells when printed

d. Since this is a financial analysis tool, it is best to avoid the use of red as an accent color

as red has meaning in the accounting world

9. Optional: Add a graph to visually depict any important aspect of the analysis

10. Ensure the spreadsheet is formatted to print nicely... (There is no need to actually print the

spreadsheet. Use 'print preview' to confirm the print formatting is acceptable.)

11. Once done... ...take time to enjoy the POWERFUL tool you just created. Go ahead, change

ANY variable in the tool –and watch as the change is automatically reflected throughout the

tool. Way cool. Way, WAY cool!

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you for the opportunity😃

Excel Assignment #6
Overview
Starting from 'a clean slate', create a business analysis tool to calculate a business's potential profit
(or loss) using MULTIPLE input variables.

Learning objectives




Excel presentation skills (clear, easy to comprehend format, use of color)
Use of formulas
Use of MANY variables to derive a single, all-encompassing 'bottom line' calculation

Assignment directions
1. Students have LOTS of latitude in this assignment. Students may build an analysis too similar in
content and/or format to the 'Buggy Supplies 'R Us' example below, or build an analysis tool for
any business opportunity using their own content and format..
2. The analysis tool must accommodate AT LEAST 6 revenue streams and AT LEAST 6 types of
expenses. Some of the revenue streams and some of the expenses must allow for the input of
two variables. (e.g., quantity sold * selling price –or- number of employees * annual rate)
3. Provide subtotals for each logical block of information
4. Format the analysis so there is a nice flow to it and it is easy to comprehend. Use grid lines and
color to clarify and emphasize.
5. Provide a 'BOTTOM LINE' block that summarizes the projections of all anticipated revenues and
expenses
6. Be sure to validate the accuracy of ALL calculated values!
7. In a cell adjacent to 'the bottom line' section, develop an 'IF' statement that displays an
appropriate messa...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags