I need a budget model to forecast the cash flow on a monthly basis for a property company.
The budget model should excist of:
1) Data sheet where you can type in different costs like rent, administration cost, loan values (payment of the loan and the interest expenses).
It should be possible to type in e.g. the rent, say 10000 per year - and then from a dropdown choose that the rent is paid monthly, quarterly or yearly starting with a date you choose - the rent is then spread out on the year accordingly so e.g. rent 10000 and paid yearly with start in 1. April - then there are made 3 payments in the rest of the year of 2500.
There should also be a possibility to make a price indexation of x percentage on a specific date.
Based on the data sheet there should be made a P/L sheet, balance sheet and cash flow sheet.
The budget model should be able to handle different currencies and there should be a comparison to the long term budget.
## Deliverables
The program should be made in Visual Basic for Applications
Project ID: 2718422
About the project
10 proposals
Remote project
Active 12 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $235 USD for this job