Business Plan Financials

[Ana Peña]

Hey guys, 

I got a chance to get some work done on the financials section for the business plan that can hopefully get you enough information for the class! It's not as much as I would have liked to get done, so I apologize in advance. Everything I worked on is in the Business Plan folder in the Dropbox. 

• The information that is in the paper is pretty basic, but should be all you need to work with. It just needs to be cleaned up, updated with the final model numbers, and we need to make sure the assumptions align with the other sections.  
  
• For the financial model, I'll need some help! Unfortunately I can't spend more time on it than I already have without falling behind on other classes. :-(. Right now, there are cost and pricing assumptions in there that I basically just made up, so feel free to change the numbers if you guys feel you have data to back those up.
• I recommend having one person own the model going forward, there are a lot of assumptions in there so the team can talk through those, but one of you will want to drive the excel sheet. 
• I've reached out to the healthcare business association to see if anyone from the class below mine wants to join the group! I'll keep asking around and keep you guys posted.  

Financial Model Details:

I started building the model from an existing template, but it's not perfect yet....the model that I started with was for 3 year projections, but it's just not realistic to assume we'll be making money that quickly, so I had to build out years 4, 5, and 6. Right now years 4, 5, and 6 are not 100% built out and connected to the summary tabs. Specifically, you'll need to build out

1) The year 4-6 monthly income statement tab ("Mo&Qtr Inc Stmt") to include monthly data for years 4-6 and correct the quarterly information for years 4-6 so that it's not taking into account those growth rates that are in there now. 

2) You'll also need to build out the "Staff -Detail" tab and subsequent "Headcount-Summary" and "Salary - Summary" tabs. It's not complicated work, it's just a lot of copy-paste and pull downs and making sure that things line up across tabs.  

I didn't make the original template, so if any of you feels comfortable in excel, I'm guessing that you'll take just as long (or less time) as I would to figure out how to add in the details for years 4-6 into the workings of the model. 

If you guys try to work in there and get really lost, just give me a call or send me an email and I'll try to help. (Also, if this email sounds like it's in a foreign language, let me know!) 

Again, so sorry I couldn't finish this, but I have to prep for some meetings tomorrow morning and can't work on this very much anymore. I will do my best to make it to our meeting tomorrow (if we have one?) and explain all of this in person too! 

Best, 

Ana Peña

UCLA Anderson MBA Class of 2013
ana.pe...@anderson.ucla.edu | (305) 519-1290

www.linkedin.com/in/anagpena/