AM Modeling question
I am in both Acquisitions/AM. About to close my first deal at my firm in the next two weeks and currently prepping an AM model to be ready to track performance throughout the investment cycle.
I have only worked with models relative to acquisitions in the past. How do I go about tracking Actuals? Say I have a CF tab and a Proforma tab. Do I hard code in actuals on a tab as months go by? What about inputs tabs?Sorry for the stupid question. How do you guys go about this?
Bump
Also, in Acq/AM - we do pro forma compared to our yearly & monthly projected budget / actuals and show % above/below. Also, have smaller reports for leasing activity/renewals, delinquency, whatever KPIs the boss asks for. Depending on your strategy, might do some sell/holds
Well, it depends on the quality and type of reports you get. But if you have a well thought out chart of accounts, then your invoices should track well to expenses. You could have an input tab, which is invoices per month, and your proforma tab, combine into one "consolidated" tab. When you get invoices for the new month, you input the invoices and the spreadsheet updated the new month. You should also have a cover sheet that tracks budget to actual for the month.
Rerum aliquid consequatur consectetur laboriosam et voluptatem aut. Aut ut rerum sequi minus sunt. Voluptate nesciunt ipsum voluptates quo odio. Sed ut voluptas exercitationem est esse molestiae. Id laudantium fugit suscipit explicabo veniam. Quam est adipisci rerum illum minima aut. Aliquam iusto quaerat accusantium nam ex id enim.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...