Answered You can hire a professional tutor to get the answer.
Pro Forma Income Statement Sales COGS Gross profit April May June July August SeptemberOctober November 15,174.92 16,692.41 18,362 20,197.82...
Twelve Month Pro Forma Budgeted Income Statement:
Kristin Raina Interior Designs has decided to request a bank loan to expand her business and the lender has asked for a one-year projection of revenue and expenses. In order to request the loan, you will need to create a Pro Forma one year budgeted income statement broken down over 12 months. You will need to take a look at the actual ending financial statements for February, March and April and use this data to help create the forecast for the next fiscal year of business.
For this project, you can assume that the company is expanding the business for any reason, however below are some possible options for seeking out a loan. You can use one of these options or create a unique creative alternative for expansion in building the one-year pro forma budgeted income statement:
Option 1: Kristin has decided to do a build out of a leased location.
Option 2: Kristin has decided to purchase a physical location for her business.
Option 3: A combination of the above or any other creatively unique expansion/company growth idea (consider a new product or new product line for example).
Attached is an "EXAMPLE" template that can be used, "20161028175249profarm" configurations, and the three months balance and P&L statements to help.
- Attachment 1
- Attachment 2
- Attachment 3
