Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project is Assisted Living facility! [Company Name] [Name] Pro-forma Business Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total REVENUE
Project is Assisted Living facility!
[Company Name] [Name] Pro-forma Business Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total REVENUE Operating Revenue Payer 1 Payer #2 Payer 3 Payer 84 Pevers Total Operating Income Totals TTTTTT EXPENSES Operating Expenses Salaries and Wages Contract Labor Fringe Benefits Loan Payment (Must be filled in) Accounting and Legal Services Advertising Dues and Subscriptions Employee Training Housekeeping Expense Insurance include all types of insurance) Maintenance and Repairs Office Supplies Postage Rent Expense - Building Taxes and Licenses Telephone et Provider Travel Us IIIIIIIII TTTTTTTTTTTTTTTTTT IIIII IIIIIIIII IIIIIIIIIIIIIIIIIII LIITTITUTT IIIIIIIIIIIIIIIIIIII H1111111 IIIIIIIIIIIIIIIIIIII Total Operating Expenses Total Net Income Before Taxes Totais Income Tax Expense Tot NET INCOME TOTALS In this assignment, you will incorporate what you learned in your accounting and finance classes to estimate your required start-up funding and financial projections. Download the Excel budget template and create a sample budget for one year that you will take to a commercial lender when applying for a start-up loan for your business. You may request a start-up loan in the amount of $0 to $500,000, but the loan can be for no more than $500.000 Excel (budget) portion of assignment Download the Budget Template that has been provided to you. You will notice that the 12 months of the calendar year have been inserted for you, as have the categories of Revenue and Operating Expenses. Prepare a 12-month annual budget by doing the following: 1. Under the Revenue section, list the payers from whom you will receive revenue. For ease of developing this budget, list no more than five payers. For example, this may include sources such as Medicare. Medicaid, and other from which other payer groups will you receive reimbursement? 2. Under the Operating Expenses section, review the list of expenses that has been provided to you. Delete any expenses that will not affect your business and add any additional expenses line items that you believe are needed in your type of business. 3. Be sure to NOT delete the Loan Payment line item, as this is the amount of money that you will pay back towards your loan each month. Assume that the loan is received on January 1 and the first loan payment is also due in January 4. Insert numbers for each month for all line items and to totals for each month in each section How much revenue do you expect will come in from each payer source each month and what will be the total revenue for the month? How much money do you believe will flow out of the business in the form of expenses each month and what will be the total of all expenses? Be sure to use Excel to total all rows and columns Be realistic here! Conduct external research, as needed, to determine what figures should be inserted for each line item. For example, if you start a two physician medical practice that also employs one nurse, one medical assistant and an office manager, what would be the total salaries for all of these individuals? The annual salary figure for each individual must then be divided by 12 (for 12 months in a year) to determine your monthly total salary expense 5. Using the Excel features, build a formula for the Net Income Net Loss row to see if you will be earning a profit or a loss for each month of the first year Insert your tax (month by month) totals. Then calculate your Net Income Total (month by month). [Company Name] [Name] Pro-forma Business Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total REVENUE Operating Revenue Payer 1 Payer #2 Payer 3 Payer 84 Pevers Total Operating Income Totals TTTTTT EXPENSES Operating Expenses Salaries and Wages Contract Labor Fringe Benefits Loan Payment (Must be filled in) Accounting and Legal Services Advertising Dues and Subscriptions Employee Training Housekeeping Expense Insurance include all types of insurance) Maintenance and Repairs Office Supplies Postage Rent Expense - Building Taxes and Licenses Telephone et Provider Travel Us IIIIIIIII TTTTTTTTTTTTTTTTTT IIIII IIIIIIIII IIIIIIIIIIIIIIIIIII LIITTITUTT IIIIIIIIIIIIIIIIIIII H1111111 IIIIIIIIIIIIIIIIIIII Total Operating Expenses Total Net Income Before Taxes Totais Income Tax Expense Tot NET INCOME TOTALS In this assignment, you will incorporate what you learned in your accounting and finance classes to estimate your required start-up funding and financial projections. Download the Excel budget template and create a sample budget for one year that you will take to a commercial lender when applying for a start-up loan for your business. You may request a start-up loan in the amount of $0 to $500,000, but the loan can be for no more than $500.000 Excel (budget) portion of assignment Download the Budget Template that has been provided to you. You will notice that the 12 months of the calendar year have been inserted for you, as have the categories of Revenue and Operating Expenses. Prepare a 12-month annual budget by doing the following: 1. Under the Revenue section, list the payers from whom you will receive revenue. For ease of developing this budget, list no more than five payers. For example, this may include sources such as Medicare. Medicaid, and other from which other payer groups will you receive reimbursement? 2. Under the Operating Expenses section, review the list of expenses that has been provided to you. Delete any expenses that will not affect your business and add any additional expenses line items that you believe are needed in your type of business. 3. Be sure to NOT delete the Loan Payment line item, as this is the amount of money that you will pay back towards your loan each month. Assume that the loan is received on January 1 and the first loan payment is also due in January 4. Insert numbers for each month for all line items and to totals for each month in each section How much revenue do you expect will come in from each payer source each month and what will be the total revenue for the month? How much money do you believe will flow out of the business in the form of expenses each month and what will be the total of all expenses? Be sure to use Excel to total all rows and columns Be realistic here! Conduct external research, as needed, to determine what figures should be inserted for each line item. For example, if you start a two physician medical practice that also employs one nurse, one medical assistant and an office manager, what would be the total salaries for all of these individuals? The annual salary figure for each individual must then be divided by 12 (for 12 months in a year) to determine your monthly total salary expense 5. Using the Excel features, build a formula for the Net Income Net Loss row to see if you will be earning a profit or a loss for each month of the first year Insert your tax (month by month) totals. Then calculate your Net Income Total (month by month) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started