Spreadsheet: 600254d1543570746-calculate-cost-of-service-over-5-years-based-on-services-due-frequency-copy-of-komatsu-830e-lcc-example-v2
Sheet: 3 Statement Model

 | FINANCIAL STATEMENTS |  |  | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00
 | Balance Sheet Check
 | Fixed Assets Register
 | Fixed Assets
 | Dump Truck Komatsu 830E
 | Engine ([NAME]) (30% Load Factor)P-1
 | Wheel Motor (Reman)P-6
 | Wheel Motor (Reman)P-7
 | HV Alternator (Reman)C-6
 | Total Assets
 | Depreciation
 | Dump Truck Komatsu 830E
 | Engine ([NAME]) (30% Load Factor)P-1
 | Wheel Motor (Reman)P-6
 | Wheel Motor (Reman)P-7
 | HV Alternator (Reman)C-6
 | Total Depreciation
 | Accumulated Depreciation
 | Dump Truck Komatsu 830E
 | Engine ([NAME]) (30% Load Factor)P-1
 | Wheel Motor (Reman)P-6
 | Wheel Motor (Reman)P-7
 | HV Alternator (Reman)C-6
 | Total Accumulated Depreciation
 | Net Assets
 | Income Statement
 | Reveneue
 | Maintenace cost
 | Oils & Lubricants cost
 | Fuel cost
 | Depreciation & Amortization
 | Overheads (wages)
 | Total variable cost
 | Insurance costs
 | Total Overhead cost
 | Total Expenses
 | Earnings Before Tax
 | Taxes
 | Net Earnings
 | Balance Sheet
 | Assets
 | Cash
 | Accounts Receivable
 | Inventory
 | Property & Equipment
 | Total Assets
 | Liabilities
 | Debt
 | Accounts Payable
 | Accumulated Depreciation
 | Total Liabilities
 | Shareholder's Equity
 | Equity Capital
 | [NAME]
 | Shareholder's Equity
 | Total Liabilities & Shareholder's Equity
 | Check
 | Cash Flow Statement
 | Operating Cash Flow
 | Net Earnings
 | Plus: Depreciation & Amortization
 | Less: Changes in Working Capital |  |  | 9002.650000000001 | 1702.049999999999 | 774.8499999999985 | 902.9000000000015 | 827.1499999999978
 | Cash from Operations
 | Investing Cash Flow
 | Investments in Property & Equipment |  |  | 15000 | 15000 | 15000 | 15000 | 15000
 | Cash from Investing
 | Financing Cash Flow
 | Issuance (repayment) of debt |  |  | 0 | 0 | -20000 | 0 | 0
 | Issuance (repayment) of equity |  |  | 170000 | 0 | 0 | 0 | 0
 | Cash from Financing
 | Net Increase (decrease) in Cash
 | Opening Cash Balance |  |  |  | 167971.1792 | 181209.912697878 | 183715.2565830093 | 211069.3356066046
 | Closing Cash Balance
 | Check
 | Supporting Schedules
 | Working Capital Schedule
 | Accounts Receivable |  |  | 5100.35 | 5904.3 | 6567.25 | 7117.05 | 7538.6
 | Inventory |  |  | 7804.6 | 9600.800000000001 | 9824.6 | 10530.8 | 11342
 | Accounts Payable |  |  | 3902.3 | 4800.400000000001 | 4912.3 | 5265.400000000001 | 5671
 | Net Working Capital (NWC)
 | Change in NWC
 | Depreciation Schedule
 | PPE Opening |  |  | 50000 | 45500 | 42350 | 40145 | 38601.5
 | Plus Capex |  |  | 15000 | 15000 | 15000 | 15000 | 15000
 | Less Depreciation |  |  | 19500 | 18150 | 17205 | 16543.5 | 16080.45
 | PPE Closing
 | Debt & Interest Schedule
 | Debt Opening |  |  | 50000 | 50000 | 50000 | 30000 | 30000
 | Issuance (repayment) |  |  | 0 | 0 | -20000 | 0 | 0
 | [NAME]
 | Interest Expense |  |  | 2500 | 2500 | 1500 | 900 | 900
 | Charts and [NAME]
 | Revenue
 | Gross Profit
 | Earning Before Tax
 | Operating Cash Flow
 | Investing Cash Flow
 | Financing Cash Flow