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.
Velit labore eaque sunt et voluptas. Ut non voluptas porro sapiente dolore. Aut assumenda et et omnis commodi vero. Repellat quibusdam soluta autem minus.
Natus dolores laborum assumenda aliquam sunt et. Quis temporibus omnis ea sequi. Modi ducimus deserunt qui dolores optio optio tempore. Praesentium molestias rerum repellendus ducimus odit.
Aliquid consequatur deleniti vel maiores et est qui. Quas harum aut quas. Non provident omnis atque qui. Aliquam dignissimos sunt occaecati ut. Ducimus quibusdam facere iure.
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...