P&L Assumptionsaaaaaa
P&L Assumptions
Debt Assumptions
Output
Input
***All % Inputs are of Total Sales
Assumptions
New Loan
Current Debt
Outstanding Balance
Loan Starting Period
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Remaining Duration (Months)
Interest Rate
Payment Deferral (Months)
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Month
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Total
Current Debt
Balance
Payment:
Principal
Interest
Total Payment
Ending Balance
New Loan
Balance
Payment:
Principal
Interest
Total Payment
Ending Balance
Total
Balance
Payment:
Principal
Interest
Total Payment
Ending Balance
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Total
Month 13
Month 14
Month 15
Month 16
Month 17
Month 18
Month 19
Month 20
Month 21
Month 22
Month 23
Month 24
Total
Restaurant Gross Sales
Less:
Discounts
Net Sales
Total Product Usage
Total Labor
Total COGS
Gross Profit
% of Gross Sales
General & Administrative
Operating Costs
Advertising
Occupancy
Total Operating Expenses
Net Income
% of Gross Sales
Interest Expense
Debt Payments
Net Cash Flow
% of Gross Sales
Beginning Cash On Hand/New Debt
Cummulative Cash Flow
Reset
Print All