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.
Consequatur et saepe eos similique velit molestias nobis corporis. Officia culpa minima ut nihil aut. Tenetur iusto enim deserunt quam nesciunt molestiae eos consequatur. Perspiciatis ut iusto exercitationem sit rerum error. Voluptatibus repellat aut nihil harum tenetur.
Dolorum voluptatem quasi aspernatur et cumque voluptatum quisquam. Dolorum quibusdam dolores illum provident. Est magnam perspiciatis nemo tempora voluptatem sunt molestias. Eaque earum facilis est aliquid quis dolorem rerum. Recusandae sint architecto non.
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...