Question
Company is L.S. Starrett -Draft a one-page spreadsheet showing financial history and projected performance L.S Starrett . -The rows should include revenue , expenses ,
Company is L.S. Starrett
-Draft a one-page spreadsheet showing financial history and projected performance L.S Starrett.
-The rows should include revenue, expenses,calculated profit, and calculated profit margin.
-The columns should be years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions.
-The spreadsheet must have accurate calculations and the cells of the spreadsheet should show your calculation formulas!!!!!!!!!!
-Your spreadsheet should look professional on screen and when printed (including a heading and meaningful number formatting). Submit this assignment as an Excel spreadsheet file.
Specifically, the following critical elements must be addressed:
-Show two years of financial history including revenue, expenses, calculated profit, and calculated profit margins.
-Show three years of future financial projections for revenue, expenses, calculated profit, and calculated profit margins.
-Show calculation formulas in cells where appropriate rather than "inputting" numbers.
-Identify key assumptions and conclusions regarding financial projections.
-Present data in a professional manner with headings and meaningful number formatting.
-2 References
-APA and citations
-Financial model must be submitted as an Excel spreadsheet document.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started