0 0 0 32000 6000 5000 4000 4000 4000 3000 3000 3000 0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: INC. Pro Forma Cash Flow $0 $25,000 $0 $0 $43,325 $219,638 $203,686 $213,078 $467,021 ($321,682) $451,876 ($274,266) Jan Feb Mar Apr Jul Aug Sep Oct Nov Dec ($117,184) $76,409 $76,243 $206,099 $59,582 ($130,864) ($141,502) ($82,622) $125,273 $241,299 $210,276 ($73,237) $82,433 $110,659 $100,373 $155,101 $180,258 ($231,784) ($188,186) ($58,406) $264,951 $328,563 $255,245 ($252,334) $0 $0 $0 $0 $150,000 $0 $300,000 $25,000 $0 $15,000 $0 $50,000 $0 $0 $0 Dividends $0 $0 $0 $0 $0 $0 $0 Subtotal ($9,751) $187,068 $191,616 $361,200 Net Cash Flow $53,076 $32,570 Cash Balance $108,508 $141,078 Less: Change in Accounts Receivable Change in Inventory Change in Other ST Assets Capital Expenditure May Jun $439,840 ($362,648) $0 ($150,000) ($300,000) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($29,688) ($141,028) $240,224 $269,862 $465,521 ($325,571) $12,071 ($148,122) $27,181 $40,967 ($14,549) ($35,590) ($11,557) $10,040 ($13,645) $51,305 $5,027 $32,208 $73,174 $58,626 $23,036 $11,478 $21,518 $7,873 $59,178 $153,148 SP2.29 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Short-term Interest Rate % 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Long-term Interest Rate % 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 45 45 45 45 45 45 45 45 45 45 45 SP2.30 General Assumptions 45 Payment Days Estimator 45 45 45 45 45 45 45 45 45 45 45 45 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 Tax Rate % 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% Expenses in Cash % 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% Sales on Credit % 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% Personnel Burden % 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00% Collection Days Estimator Inventory Turnover Estimator HURDLE: THE BOOK ON BUSINESS PLANNING Production Manager Assistant Technical Technical Technical Fulfillment Fulfillment Other Subtotal Sales and Marketing Manager Technical sales Technical sales Salesperson Salesperson Salesperson Salesperson Salesperson Salesperson Other Subtotal General and Administrative President Finance Admin Assistant Bookkeeping Clerical Clerical Clerical Other Subtotal Other Personnel Programming Other...
View Full Document

This note was uploaded on 01/26/2014 for the course BUINESS 102 taught by Professor Unknown during the Winter '09 term at University of Phoenix.

Ask a homework question - tutors are online