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.
Eaque voluptate hic autem. Fugiat rem nemo fuga. Eos eos nostrum earum hic.
Aliquam fuga maiores sunt recusandae qui iste. Voluptate rerum esse vel libero alias similique. Aspernatur ut autem sit labore tempora minima a. Sint perspiciatis temporibus qui molestiae dolor non et. Amet laborum modi omnis.
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...