Assignment:
The Use of Spreadsheets in Budgeting
The reports that are generated from accounting software are not always user friendly. In many cases, there is nowhere for a budget to be entered. What happens when you have an expense in a category where there was no budget? By using a spreadsheet program, such as Microsoft Excel, you can translate the report data into any format that you like. For example, you can group all of the different expense accounts based on a particular project. The possibilities are endless with the flexibility of a spreadsheet program.
Your assignment is to create a one-year budget (forecast) as a team in Excel, based on the real estate company you set up. As a team you can decide when/if you would like to do the following real estate transactions. You will explain your decisions in your team's analysis paper.
Decisions:
- Take cash/line of credit and purchase a complete one-bedroom, fixer-upper condo for $18,000. You will also need $7,000 to completely gut and rebuild the condo. This process will take one month after purchase; you are going to outsource the process. If you choose to take out a line of credit, you would have a 0% financing offer up to $25,000 for 15 months. Remember you can also use cash. You decide what you would charge for rent and the HOA fees would be the same as the other condo you purchased. The property taxes are $1,676 annually (139.67 per month)
- Would you like to sell any of the properties? If so which one and why? Currently the appraisal on the condo is $135,000 and the house is $70,800.
- What about raising the rent on the properties?
- Are there any other business decisions you would like to make?