Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance

Authors: John P. Wiedemer, ‎ Keith J. Baker

9th edition

324181426, 324181425, 978-0324181425

More Books

Students also viewed these Finance questions