Excel Spreadsheet

Projected FS for Bank Template

You must be logged in to download this document
Reviews
Shared by: Katrina Golden
Stats
views:
74
downloads:
7
rating:
not rated
reviews:
0
posted:
4/8/2008
language:
English
pages:
0
Capital Imaging, Inc. Projected Cash Flow As of 12/31/04 2004 Total Revenues Total Direct Costs Total Wage Costs Gross Profit Operating Expenses Depreciation Expense Total Officer Compsenation Net Income 2,024,684.93 449,982.92 528,389.50 1,046,312.51 539,534.13 194,229.11 155,883.00 156,666.27 100% 2005 2,227,153.42 494,981.21 581,228.45 1,150,943.76 593,487.54 150,000.00 155,883.00 251,573.22 150,000.00 (150,000.00) 251,573.22 (105,181.56) (50,000.00) 96,391.66 100% 2006 2,449,868.77 544,479.33 639,351.30 1,266,038.14 652,836.30 125,000.00 155,883.00 332,318.84 160,000.00 (160,000.00) 332,318.84 (105,181.56) (60,000.00) 167,137.28 100% 2007 2,694,855.64 598,927.27 703,286.42 1,392,641.95 718,119.93 130,000.00 155,883.00 388,639.02 170,000.00 (170,000.00) 388,639.02 (105,181.56) (70,000.00) 213,457.46 100% 2008 2,964,341.21 658,819.99 773,615.07 1,531,906.15 789,931.92 130,000.00 155,883.00 456,091.23 170,000.00 (170,000.00) 456,091.23 (105,181.56) (80,000.00) 270,909.67 100% 2009 2,964,341.21 658,819.99 773,615.07 1,531,906.15 789,931.92 130,000.00 155,883.00 456,091.23 170,000.00 (170,000.00) 456,091.23 (105,181.56) (80,000.00) 270,909.67 100% 2010 2,964,341.21 658,819.99 773,615.07 1,531,906.15 789,931.92 130,000.00 155,883.00 456,091.23 170,000.00 (170,000.00) 456,091.23 (105,181.56) (80,000.00) 270,909.67 100% 2011 2,964,341.21 658,819.99 773,615.07 1,531,906.15 789,931.92 130,000.00 155,883.00 456,091.23 170,000.00 (170,000.00) 456,091.23 (105,181.56) (80,000.00) 270,909.67 100% 22.22% 22.22% 22.22% 22.22% 22.22% 22.22% 22.22% 22.22% 26.10% 26.10% 26.10% 26.10% 26.10% 26.10% 26.10% 26.10% 51.68% 51.68% 51.68% 51.68% 51.68% 51.68% 51.68% 51.68% 26.65% 26.65% 26.65% 26.65% 26.65% 26.65% 26.65% 26.65% 9.59% 6.74% 5.10% 4.82% 4.39% 4.39% 4.39% 4.39% 7.70% 7.00% 6.36% 5.78% 5.26% 5.26% 5.26% 5.26% 7.74% 11.30% 13.56% 14.42% 15.39% 15.39% 15.39% 15.39% Add: Depreciation Expense 194,229.11 Less: New Equipment (227,728.91) Net Cash Flow before Loan payment Shareholder Distributions Net Cash Flow 123,166.47 0.00 (40,000.00) 83,166.47 4/8/2008 at 3:26 PM Page: 1 Company Projected Balance Sheets As of 12/31/04 Cash Other Current Assets Total Current Assets Other Non-Current Assets Total Assets Current Liabilities Non-Current Liabilities Total Liabilities Common Stock Beginning Retained Earnings Less: Distributions Less: Note Payment Add: Current Year Profit Ending Retained Earnings Total Equity Total Liabilities & Equity 2004 94,932 279,256 374,188 427,147 801,335 354,084 304,537 658,621 25,000 1,048 (40,000) 0 156,666 117,714 142,714 801,335 2005 191,324 279,256 470,580 427,147 897,727 354,084 304,537 658,621 25,000 117,714 (50,000) (105,182) 251,573 214,106 239,106 897,727 2006 358,461 279,256 637,717 427,147 1,064,864 354,084 304,537 658,621 25,000 214,106 (60,000) (105,182) 332,319 381,243 406,243 1,064,864 2007 571,918 279,256 851,174 427,147 1,278,321 354,084 304,537 658,621 25,000 381,243 (70,000) (105,182) 388,639 594,700 619,700 1,278,321 2008 842,828 279,256 1,122,084 427,147 1,549,231 354,084 304,537 658,621 25,000 594,700 (80,000) (105,182) 456,091 865,610 890,610 1,549,231 2009 1,113,738 279,256 1,392,994 427,147 1,820,141 354,084 304,537 658,621 25,000 865,610 (80,000) (105,182) 456,091 1,136,520 1,161,520 1,820,141 2010 1,384,647 279,256 1,663,903 427,147 2,091,050 354,084 304,537 658,621 25,000 1,136,520 (80,000) (105,182) 456,091 1,407,429 1,432,429 2,091,050 2011 1,655,557 279,256 1,934,813 427,147 2,361,960 354,084 304,537 658,621 25,000 1,407,429 (80,000) (105,182) 456,091 1,678,339 1,703,339 2,361,960 Company Projected Cash Flow As of (Month Day, Year) Current Year Total Revenues Total Direct Costs Total Wage Costs Gross Profit Operating Expenses Depreciation Expense Interest Expense Total Officer Compsenation Net Income Add: Depreciation Expense Less: New Equipment Net Cash Flow before Principal loan payments Shareholder Distributions Net Cash Flow 2,000,000.00 5,000.00 528,389.50 1,466,610.50 513,451.48 194,229.11 26,082.65 155,883.00 576,964.26 194,229.11 (227,728.91) 543,464.46 0.00 (40,000.00) 503,464.46 100% 0.25% 26.42% 73.33% 25.67% 9.71% 1.30% 7.79% 28.85% Next Year 100% 0.25% In Two Years 2,420,000.00 6,050.00 100% 0.25% In Three Years 2,662,000.00 6,655.00 100% 0.25% In Four Years 2,928,200.00 7,320.50 773,615.07 2,147,264.43 751,744.31 130,000.00 27,067.26 155,883.00 1,082,569.86 130,000.00 (130,000.00) 1,082,569.86 (129,714.38) (30,000.00) 922,855.48 100% 0.25% 26.42% 73.33% 25.67% 4.44% 0.92% 5.32% 36.97% In Five Years 2,928,200.00 7,320.50 100% 0.25% In Six Years 2,928,200.00 7,320.50 773,615.07 2,147,264.43 751,744.31 130,000.00 12,465.52 155,883.00 1,097,171.60 130,000.00 (130,000.00) 1,097,171.60 (129,179.00) (40,000.00) 927,992.60 100% 0.25% 26.42% 73.33% 25.67% 4.44% 0.43% 5.32% 37.47% In Seven Years 2,928,200.00 7,320.50 100% 0.25% 2,200,000.00 5,500.00 581,228.45 26.42% 1,613,271.55 73.33% 564,796.63 25.67% 125,000.00 55,617.53 155,883.00 5.68% 2.53% 7.09% 639,351.30 26.42% 1,774,598.71 73.33% 621,276.29 25.67% 75,000.00 44,825.28 155,883.00 3.10% 1.85% 6.44% 703,286.42 26.42% 1,952,058.58 73.33% 683,403.92 25.67% 50,000.00 34,713.58 155,883.00 1.88% 1.30% 5.86% 773,615.07 26.42% 2,147,264.43 73.33% 751,744.31 25.67% 130,000.00 19,970.12 155,883.00 4.44% 0.68% 5.32% 773,615.07 26.42% 2,147,264.43 73.33% 751,744.31 25.67% 130,000.00 4,497.80 155,883.00 4.44% 0.15% 5.32% 711,974.39 32.36% 125,000.00 (50,000.00) 786,974.39 (215,054.47) 0.00 571,919.92 877,614.13 36.27% 75,000.00 (50,000.00) 902,614.13 (206,810.49) (10,000.00) 685,803.64 1,028,058.08 38.62% 50,000.00 (120,000.00) 958,058.08 (167,760.65) (20,000.00) 770,297.43 1,089,667.00 37.21% 130,000.00 (130,000.00) 1,089,667.00 (124,809.08) (40,000.00) 924,857.92 1,105,139.32 37.74% 130,000.00 (130,000.00) 1,105,139.32 (137,146.72) (40,000.00) 927,992.60 4/8/2008 at 3:26 PM Page: 3 Company Projected Balance Sheets As of 12/31/04 Cash Other Current Assets Total Current Assets Other Non-Current Assets Total Assets Current Liabilities Non-Current Liabilities Total Liabilities Common Stock Beginning Retained Earnings Less: Distributions Less: Stock Buyback Add: Current Year Profit Ending Retained Earnings Total Equity Total Liabilities & Equity 2004 94,932 279,256 374,188 427,147 801,335 354,084 304,537 658,621 25,000 1,048 (40,000) 2005 666,852 279,256 946,108 352,147 1,298,255 354,084 689,483 1,043,567 25,000 117,714 0 (600,000) 2006 1,352,656 279,256 1,631,912 327,147 1,959,059 354,084 482,672 836,756 25,000 229,688 (10,000) 2007 2,122,953 279,256 2,402,209 397,147 2,799,356 354,084 314,911 668,995 25,000 1,097,303 (20,000) 2008 3,045,808 279,256 3,325,064 397,147 3,722,211 354,084 185,197 539,281 25,000 2,105,361 (30,000) 2009 3,970,666 279,256 4,249,922 397,147 4,647,069 354,084 60,388 414,472 25,000 3,157,930 (40,000) 2010 4,898,659 279,256 5,177,915 397,147 5,575,062 285,293 0 285,293 25,000 4,207,597 (40,000) 2011 5,826,652 279,256 6,105,908 397,147 6,503,055 156,113 0 156,113 25,000 5,264,769 (40,000) 156,666 117,714 142,714 801,335 711,974 229,688 254,688 1,298,255 877,614 1,097,303 1,122,303 1,959,059 1,028,058 2,105,361 2,130,361 2,799,356 1,082,570 3,157,930 3,182,930 3,722,211 1,089,667 4,207,597 4,232,597 4,647,069 1,097,172 5,264,769 5,289,769 5,575,062 1,097,172 6,321,941 6,346,941 6,503,054 Company Projected Debt Service As of 12/31/04 Equipment Equipment Equipment Equipment Equipment Equipment New Loan Interest 2005 Principal 20,027.79 74,514.76 3,315.48 5,354.12 3,416.55 12,656.04 95,769.73 215,054.47 Interest 2006 Principal 1,711.01 77,937.96 3,519.96 5,661.77 3,647.16 12,656.04 Interest 2007 Principal Interest 2008 Principal Interest 2009 Principal Interest 2010 Principal Interest 2011 Principal 727.65 6,845.24 584.52 861.88 723.45 0.00 45,874.79 55,617.53 8.20 3,422.04 380.04 554.23 492.84 0.00 378.39 162.92 228.89 246.65 0.00 33,539.28 3,737.08 5,987.11 3,893.35 12,656.04 3.85 24.66 0.00 817.00 1,635.57 12,656.04 0.00 3,134.68 12,465.52 129,179.00 12,465.52 129,179.00 4,497.80 137,146.72 4,497.80 137,146.72 39,967.93 101,676.59 44,825.28 206,810.49 33,696.73 107,947.79 34,713.58 167,760.65 27,038.75 114,605.77 27,067.26 129,714.38 19,970.12 121,674.40 19,970.12 124,809.08
0
Related docs
Projected FS for Bank Template
Views: 74  |  Downloads: 7
Projected Balance Sheet Template
Views: 34  |  Downloads: 4
Business Template
Views: 134  |  Downloads: 15
Projected Balance Sheet Template
Views: 96  |  Downloads: 12
Projected_Balance Sheet Template
Views: 315  |  Downloads: 20
Projected Balance Sheet Template[1]
Views: 62  |  Downloads: 2
C Projected_Balance_Sheet3[1]
Views: 16  |  Downloads: 0
Projected Balance Sheet
Views: 395  |  Downloads: 40
Projected_Balance_Sheet
Views: 208  |  Downloads: 13
C Projected Balance Sheet 3 Template
Views: 351  |  Downloads: 8
projected_balance_sheet
Views: 397  |  Downloads: 47
projected_balance_sheet
Views: 425  |  Downloads: 38
Overview of Projected Releases
Views: 16  |  Downloads: 1
Projected GPA Worksheet
Views: 3  |  Downloads: 0
Other docs by Katrina Golden
20XX Tax Planning Opportunity template
Views: 209  |  Downloads: 9
Bylaws__Corporation__FIRM_FORM Template
Views: 161  |  Downloads: 11
Corporate_Bylaws Template
Views: 232  |  Downloads: 27
CORPORATION_RESOLUTION Template
Views: 196  |  Downloads: 18
BankLoanRequestforSmallBusiness Template
Views: 174  |  Downloads: 14
Work for Hire and proprietary Agreement template
Views: 221  |  Downloads: 9
Weekly Time Card Template[1]
Views: 241  |  Downloads: 5
Vacation_Master template
Views: 204  |  Downloads: 9
Travel_expense_report_with_mileage_due Template
Views: 264  |  Downloads: 17
Summary_of_PTO_and_Vacation_Time template
Views: 178  |  Downloads: 12