Amortization & Depreciation Schedule | ||||||||||||||||
Prepared By: | Company Name: | Return to Starting Point | ||||||||||||||
Sam Miller | Aviator Inc | |||||||||||||||
Commercial Loan | ||||||||||||||||
Principal Amount | $ - | |||||||||||||||
Interest Rate | 9.00% | |||||||||||||||
Loan Term in Months | 84.00 | |||||||||||||||
Monthly Payment Amount | $0.00 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Two | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Three | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Commercial Mortgage | ||||||||||||||||
Principal Amount | $ - | |||||||||||||||
Interest Rate | 9.00% | |||||||||||||||
Loan Term in Months | 240.00 | |||||||||||||||
Monthly Payment Amount | $0.00 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Two | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Three | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Credit Card Debt | ||||||||||||||||
Principal Amount | $ - | |||||||||||||||
Interest Rate | 7.00% | |||||||||||||||
Loan Term in Months | 60.00 | |||||||||||||||
Monthly Payment Amount | $0.00 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Two | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Three | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Vehicle Loans | ||||||||||||||||
Principal Amount | $ - | |||||||||||||||
Interest Rate | 6.00% | |||||||||||||||
Loan Term in Months | 48.00 | |||||||||||||||
Monthly Payment Amount | $0.00 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Two | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Three | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Other Bank Debt | ||||||||||||||||
Principal Amount | $0.00 | |||||||||||||||
Interest Rate | 5.00% | |||||||||||||||
Loan Term in Months | 36.00 | |||||||||||||||
Monthly Payment Amount | $0.00 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Two | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Year Three | ||||||||||||||||
Interest | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Principal | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |||
Loan Balance | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Depreciation | ||||||||||||||||
Real Estate-Buildings | 20 | |||||||||||||||
Leasehold Improvements | 7 | |||||||||||||||
Equipment | 7 | |||||||||||||||
Furniture and Fixtures | 5 | |||||||||||||||
Vehicles | 5 | |||||||||||||||
Other | 5 | |||||||||||||||
Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | ||||
Year One | ||||||||||||||||
Starting Depreciation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Additional Depreciation | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Ending Depreciation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Year Two | ||||||||||||||||
Starting Depreciation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Additional Depreciation | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Ending Depreciation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Year Three | ||||||||||||||||
Starting Depreciation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Additional Depreciation | - | - | - | - | - | - | - | - | - | - | - | - | ||||
Ending Deprecation | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | 1,044,643 | $ 12,535,714 | |||
Amortization of Start-Up Costs | Monthly | |||||||||||||||
Prepaid Expenses | $ 47,000,000 | |||||||||||||||
Total Expensed each Year | $ 15,666,667 | 1305556 | ||||||||||||||
Other Initial Costs | $ 12,500,000 | |||||||||||||||
Total Expensed each Year | $ 4,166,667 | 347222 | ||||||||||||||
Prepaid Expenses | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | |||
Year One | ||||||||||||||||
Amount Amortized | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | $ 15,666,667 | |||
Total Amortized | 1,305,556 | 2,611,111 | 3,916,667 | 5,222,222 | 6,527,778 | 7,833,333 | 9,138,889 | 10,444,444 | 11,750,000 | 13,055,556 | 14,361,111 | 15,666,667 | ||||
Year Two | ||||||||||||||||
Amount Amortized | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | $ 15,666,667 | |||
Total Amortized | 16,972,222 | 18,277,778 | 19,583,333 | 20,888,889 | 22,194,444 | 23,500,000 | 24,805,556 | 26,111,111 | 27,416,667 | 28,722,222 | 30,027,778 | 31,333,333 | ||||
Year Three | ||||||||||||||||
Amount Amortized | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | 1,305,556 | $ 15,666,667 | |||
Total Amortized | 32,638,889 | 33,944,444 | 35,250,000 | 36,555,556 | 37,861,111 | 39,166,667 | 40,472,222 | 41,777,778 | 43,083,333 | 44,388,889 | 45,694,444 | 47,000,000 | ||||
Other Initial Costs | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Totals | |||
Year One | ||||||||||||||||
Amount Amortized | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | $ 4,166,667 | |||
Total Amortized | 347,222 | 694,444 | 1,041,667 | 1,388,889 | 1,736,111 | 2,083,333 | 2,430,556 | 2,777,778 | 3,125,000 | 3,472,222 | 3,819,444 | 4,166,667 | ||||
Year Two | ||||||||||||||||
Starting Depreciation | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | $ 4,166,667 | |||
Ending Depreciation | 4,513,889 | 4,861,111 | 5,208,333 | 5,555,556 | 5,902,778 | 6,250,000 | 6,597,222 | 6,944,444 | 7,291,667 | 7,638,889 | 7,986,111 | 8,333,333 | ||||
Year Three | ||||||||||||||||
Starting Depreciation | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | 347,222 | $ 4,166,667 | |||
Ending Deprecation | 8,680,556 | 9,027,778 | 9,375,000 | 9,722,222 | 10,069,444 | 10,416,667 | 10,763,889 | 11,111,111 | 11,458,333 | 11,805,556 | 12,152,778 | 12,500,000 | ||||