Business Plan for an Publication and Media Company
bixgyn.zhou
StartupCashFlowProforma.xlsxSheet1
| Moonlight Literature, LLC., 2020 Income/Expenses | Jan. | Feb. | March | April | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. | Totals: |
| Pre-startup Funds/(Expenses) $100,000(Bank Loan) | |||||||||||||
| Carry Forward Balance | -59,567 | -32,617 | 12,181 | 84,037 | 196,791 | 371,222 | 638,527 | 1,045,526 | 1,662,480 | 2,594,810 | 4,000,686 | 10,514,077 | |
| Cash | 100,000 | 126,000 | 165,000 | 223,500 | 311,250 | 442,875 | 640,313 | 936,469 | 1,380,703 | 2,047,055 | 3,046,582 | 4,545,873 | 13,965,619 |
| Sales/Loans/Investments/Misc. | 26,000 | 39,000 | 58,500 | 87,750 | 131,625 | 197,438 | 296,156 | 444,234 | 666,352 | 999,527 | 1,499,291 | 2,248,937 | 6,694,810 |
| Sub. Total: $20660429 | 126,000 | 165,000 | 223,500 | 311,250 | 442,875 | 640,313 | 936,469 | 1,380,703 | 2,047,055 | 3,046,582 | 4,545,873 | 6,794,810 | 20,660,429 |
| Cost of Goods Sold | 2,300 | 5,850 | 8,775 | 13,163 | 19,744 | 29,616 | 44,423 | 66,635 | 99,953 | 149,929 | 224,894 | 337,340 | 1,002,621 |
| Gross Margins: $19657807 | 123,700 | 159,150 | 214,725 | 298,088 | 423,131 | 610,697 | 892,045 | 1,314,068 | 1,947,102 | 2,896,653 | 4,320,979 | 6,457,469 | 19,657,807 |
| Expenses | |||||||||||||
| SGA General and Administrative | |||||||||||||
| Salaries, Comm., Fees | 30,000 | 33,000 | 36,300 | 39,930 | 43,923 | 48,315 | 53,147 | 58,462 | 64,308 | 70,738 | 77,812 | 85,594 | 641,529 |
| Payroll taxes | 4,500 | 4,950 | 5,445 | 5,990 | 6,588 | 7,247 | 7,972 | 8,769 | 9,646 | 10,611 | 11,672 | 12,839 | 96,229 |
| Marketing/Advertising | 100,000 | 105,000 | 110,250 | 115,763 | 121,551 | 127,628 | 134,010 | 140,710 | 147,746 | 155,133 | 162,889 | 171,034 | 1,591,713 |
| Overhead | |||||||||||||
| Rent | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 48,000 |
| Equipment | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 36,000 |
| Utilities | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4,800 |
| Insurance | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 12,000 |
| Telecommunications | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Professional Services | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Office Supplies | 3,000 | 3,150 | 3,308 | 3,473 | 3,647 | 3,829 | 4,020 | 4,221 | 4,432 | 4,654 | 4,887 | 5,131 | 47,751 |
| Maintenance | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 12,000 |
| Interest on Loans(20%) | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 1,667 | 20,000 |
| Opperating | |||||||||||||
| Book/Magazine/Journal Print | 30,000 | 31,500 | 33,075 | 34,729 | 36,465 | 38,288 | 40,203 | 42,213 | 44,324 | 46,540 | 48,867 | 51,310 | 477,514 |
| Website Mantenance | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 12,000 |
| Others | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 24,000 |
| Misc. | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1,200 |
| Total Expenses ($ 3024736 ) | 181,667 | 191,767 | 202,544 | 214,050 | 226,340 | 239,475 | 253,518 | 268,542 | 284,622 | 301,843 | 320,294 | 340,074 | 3,024,736 |
| Net Income before taxes/(loss) $ 17635693 | -55,667 | -26,767 | 20,956 | 97,200 | 216,535 | 400,838 | 682,951 | 1,112,161 | 1,762,433 | 2,744,740 | 4,225,579 | 6,454,735 | 17,635,693 |
| Other taxes ($1004221 ) | 3,900 | 5,850 | 8,775 | 13,163 | 19,744 | 29,616 | 44,423 | 66,635 | 99,953 | 149,929 | 224,894 | 337,340 | 1,004,221 |
| Net Income/(loss) $16631472 | -59,567 | -32,617 | 12,181 | 84,037 | 196,791 | 371,222 | 638,527 | 1,045,526 | 1,662,480 | 2,594,810 | 4,000,686 | 6,117,395 | 16,631,472 |
Pre-startup Expenses Sample Startup, LLC. Cash Flow Proforma 2020, 12 month Yixuan Zhou(Laven)
Sheet2
| Second year Cash Flow Proforma (Quarterly) | |||||
| Moonlight Literature, LLC., 2020 Income/Expenses | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Totals: |
| Pre-startup Funds/(Expenses) $100,000(Bank Loan) | |||||
| Carry Forward Balance | 12,343,740 | 21,384,537 | 39,466,833 | 73,195,110 | |
| Cash | 9,043,747 | 18,087,494 | 36,174,988 | 72,349,976 | 135,656,205 |
| Sales/Loans/Investments/Misc. | 4,497,874 | 4,497,874 | 4,497,874 | 4,497,874 | 17,991,496 |
| Sub. Total: $153647701 | 13,541,621 | 22,585,368 | 40,672,862 | 76,847,850 | 153,647,701 |
| Cost of Goods Sold | 674,680 | 674,680 | 674,680 | 674,680 | 2,698,720 |
| Gross Margins: $150948981 | 12,866,941 | 21,910,688 | 39,998,182 | 76,173,170 | 150,948,981 |
| Expenses | |||||
| SGA General and Administrative | |||||
| Salaries, Comm., Fees | 171,188 | 171,188 | 171,188 | 171,188 | 684,752 |
| Payroll taxes | 25,678 | 25,678 | 25,678 | 25,678 | 102,713 |
| Marketing/Advertising | 171,034 | 171,034 | 171,034 | 171,034 | 684,136 |
| Overhead | |||||
| Rent | 20,000 | 20,000 | 20,000 | 20,000 | 80,000 |
| Equipment | 9,000 | 9,000 | 9,000 | 9,000 | 36,000 |
| Utilities | 12,000 | 12,000 | 12,000 | 12,000 | 48,000 |
| Insurance | 3,000 | 3,000 | 3,000 | 3,000 | 12,000 |
| Telecommunications | 0 | 0 | 0 | 0 | 0 |
| Professional Services | 0 | 0 | 0 | 0 | 0 |
| Office Supplies | 9,000 | 9,450 | 9,923 | 10,419 | 38,791 |
| Maintenance | 3,000 | 1,000 | 1,000 | 1,000 | 6,000 |
| Interest on Loans | 0 | 0 | 0 | 0 | 0 |
| Opperating | |||||
| Book/Magazine/Journal Print | 90,000 | 94,500 | 99,225 | 104,186 | 387,911 |
| Website Mantenance | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 |
| Others | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 |
| Misc. | 300 | 300 | 300 | 300 | 300 |
| Total Expenses ($2117503 ) | 523,200 | 526,150 | 531,348 | 536,805 | 2,117,503 |
| Net Income before taxes/(loss) $ 151530198 | 13,018,421 | 22,059,218 | 40,141,514 | 76,311,045 | 151,530,198 |
| Other taxes ($2698724 ) | 674,681 | 674,681 | 674,681 | 674,681 | 2,698,724 |
| Net Income/(loss) $148831473 | 12,343,740 | 21,384,537 | 39,466,833 | 75,636,364 | 148,831,473 |
