- Prepare the Financial Statement Report (which was started in BUS 538 Accounting for Managers). Start with what you created for that course and add the following information and ratios calculated from the projections for Year 1,2 and 3 of your business. (2 hour / 4 hours) (W8.1-2)
- General Assumptions concerning the financial statements
- Minimum of $30,000 loan
- An open line of credit to grease the cash flow
- A minimum of the 50 percent of the business is financed with debt
- Assumptions for the pro forma financial statements
- Depreciation Schedule
- Amortization Schedule
- Comparison/Analysis of their companys ratio with industry ratios including some, if not all, of the following:
- Liquidity ratios
- Asset Management Ratios
- Financial Leverage Management ratios
- Profitability ratios
(WAT to W7:3) 2. Prepare the Financial Statement Report (which was started in BUS 538 Accounting for Managers). Start with what you created for that course and add 1-1918 US 568 William Woods University c D Fixed Assets Amount Depreciation (years) Worlding Capital (Cash On Hand) Total Operating Capital Total Required Funds $ $ 6.525 8,525 Totals Loan Rate Not Depreciated 20 7 7 Term In Months Monthly Payments Percentage 52.20% 47 80% 4450 4,075 1.000 Real Estate-Land Real Estate Buildings Leasehold Improvements Equipment Furniture and Fixtures Vehicles Other Total Fixed Assets 5 5 5 Sources of Funding Owner's Equity Outside Investors Additional Loans or Debt Commercial Loan Commercial Mortgage Credit Card Debt Vehicle Loans Other Bank Debt Total Sources of Funding Total Funding Needed 161 45 the following information and ratios calculated from the projections for Year 1,2 and 3 of your business. (2 hour /4 hours) (W8.1-2) 99 1,000 2.000 117.30% 58.65% 58.65% 93.84% 23.46% 451.91%$ $ $ 10,000 5.000 5.000 8,000 2.000 38,525 (30,000) 188 9.00% 240 700 60 6.00% 48 5.00% Cell D 42 must equal cell CBI $ Your funding exceeds your needs. Not Balanced) 36 60 553 Amount NO General Assumptions concerning the financial statements O Minimum of $30,000 loan 5,000 200 o Open line of credit to "grease" the cash flow Note: For existing businesses, this should be the "bucket of cash plus receivables that will be turned into cash, minus payables that will be paid out in cash in the near term (i.e. in the first months of the plan) - Existing Businesses ONLY - Calculating Cash on Hand Cash + Accounts Receivable + Prepaid Expenses - Accounts Payable - Accrued Expenses Total Cash on Hand $ Operating Capital Pre-Opening Salaries and Wages Prepaid Insurance Premiums Inventory Legal and Accounting Fees Rent Deposits Udlity Deposits Supplies Advertising and Promotions Licenses Other Initial Start-Up Costs Working Capital (Cash On Hand Total Operating Capital Total Required Funds o A minimum of the 50 percent of the business is financed with debt o Assumptions for the pro forma financial statements 500 200 125 500 Depreciation Schedule $ Amortization Schedule 6.525 8,525 $ Comparison/Analysis of their company's ratio with industry ratios including some, if not all of the following: Loar Sources of Funding 4 AEA Percentage Totals EAN 2a-Payroll Year1 2b-PayrollYrs1-3 ...E Directions 3a-Sale 3b-SalesForecast Yrs1-3 3a-SalesForecastYeart 1-Starting point o Liquidity ratios 2a-PayrollYear 26-PayrollYrs1-3 Directions 1-Starting point o Asset Management ratios o Financial Leverage Management ratios MacBook M o Profitability ratios 3 Praeant tha finnnoinl noti info Stot Daarnain (WAT to W7:3) 2. Prepare the Financial Statement Report (which was started in BUS 538 Accounting for Managers). Start with what you created for that course and add 1-1918 US 568 William Woods University c D Fixed Assets Amount Depreciation (years) Worlding Capital (Cash On Hand) Total Operating Capital Total Required Funds $ $ 6.525 8,525 Totals Loan Rate Not Depreciated 20 7 7 Term In Months Monthly Payments Percentage 52.20% 47 80% 4450 4,075 1.000 Real Estate-Land Real Estate Buildings Leasehold Improvements Equipment Furniture and Fixtures Vehicles Other Total Fixed Assets 5 5 5 Sources of Funding Owner's Equity Outside Investors Additional Loans or Debt Commercial Loan Commercial Mortgage Credit Card Debt Vehicle Loans Other Bank Debt Total Sources of Funding Total Funding Needed 161 45 the following information and ratios calculated from the projections for Year 1,2 and 3 of your business. (2 hour /4 hours) (W8.1-2) 99 1,000 2.000 117.30% 58.65% 58.65% 93.84% 23.46% 451.91%$ $ $ 10,000 5.000 5.000 8,000 2.000 38,525 (30,000) 188 9.00% 240 700 60 6.00% 48 5.00% Cell D 42 must equal cell CBI $ Your funding exceeds your needs. Not Balanced) 36 60 553 Amount NO General Assumptions concerning the financial statements O Minimum of $30,000 loan 5,000 200 o Open line of credit to "grease" the cash flow Note: For existing businesses, this should be the "bucket of cash plus receivables that will be turned into cash, minus payables that will be paid out in cash in the near term (i.e. in the first months of the plan) - Existing Businesses ONLY - Calculating Cash on Hand Cash + Accounts Receivable + Prepaid Expenses - Accounts Payable - Accrued Expenses Total Cash on Hand $ Operating Capital Pre-Opening Salaries and Wages Prepaid Insurance Premiums Inventory Legal and Accounting Fees Rent Deposits Udlity Deposits Supplies Advertising and Promotions Licenses Other Initial Start-Up Costs Working Capital (Cash On Hand Total Operating Capital Total Required Funds o A minimum of the 50 percent of the business is financed with debt o Assumptions for the pro forma financial statements 500 200 125 500 Depreciation Schedule $ Amortization Schedule 6.525 8,525 $ Comparison/Analysis of their company's ratio with industry ratios including some, if not all of the following: Loar Sources of Funding 4 AEA Percentage Totals EAN 2a-Payroll Year1 2b-PayrollYrs1-3 ...E Directions 3a-Sale 3b-SalesForecast Yrs1-3 3a-SalesForecastYeart 1-Starting point o Liquidity ratios 2a-PayrollYear 26-PayrollYrs1-3 Directions 1-Starting point o Asset Management ratios o Financial Leverage Management ratios MacBook M o Profitability ratios 3 Praeant tha finnnoinl noti info Stot Daarnain
