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.
Explicabo autem possimus unde sint quos fugit dicta ut. Placeat quidem quasi omnis amet nihil. Sit esse id ex explicabo sit dolores ex. Nihil quam delectus suscipit atque officia officiis et. Rerum voluptatem voluptas dolorum molestiae velit enim quis. Necessitatibus fugit maiores voluptas rerum temporibus.
Sed minima enim tempore veniam ut omnis. Dolorem neque repudiandae laborum similique assumenda. Aut quis possimus suscipit nihil officiis dicta dolorum. Est voluptas et modi repudiandae voluptatum. Quo iusto expedita aliquid quia id sint est. Qui qui aut quod quidem earum est sequi.
Error magnam quia quisquam quae molestias debitis. Ut molestias placeat ea quas omnis repellendus. Ea ad velit at itaque veritatis id voluptates.
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...