Creating an Excel spreadsheet
rohankhemka
IIAssignmentInstructions1.pptxII ASSIGNMENT
P&L FINANCIAL PROJECTIONS ON EXCEL UNTIL EBITDA
SEND YOUR EXCEL FILE BY EMAIL BY MAY 19TH
IT WILL BE VALUED –> 20% WEIGHT ON TOTAL GRADE OF THE COURSE
BUILD YOUR MODEL ON EXCEL FOLLOWING THE GIVEN EXAMPLES, AS FOLLOWS
General Assumptions
Volumes
Price per unit
Variable cost per unit
Overhead costs (included sources)
Revenue for each product/service calculated from assumptions sheet:
Unit volume x price per unit
Cost for each product/service calculated from assumptions sheet:
Unit volume x variable cost (or COGS if any) per unit
Overhead (SG&A) costs
ASSUMPTIONS SHEET:
REVENUE SHEET:
COST SHEET:
INCOME STATEMENT (P&L) SHEET (OUTPUT) UNITIL EBITDA
4 SHEETS (more for charts or graphics)
