Microsoft Excel Business Analyst for Property
Budget: $10 – $30 AUD
Excel Skill
Background:
You are working for a buy-build-and-sale firm which is considering various options in and around a few suburbs in Victoria. As for a typical deal, the company buys an empty land on some selected suburb, builds a new house on the land, and then sells the house to investor(s). The combination of interest payments, opportunity costs, building costs, and taxes require the company to build and sell as quickly as possible, while maintaining a high-quality product. For simplicity, we only assume costs as empty land purchase and building of a new house, and revenues as resale of the new house (with land).
There is regular debate among senior managers about where is the best suburb to do their business. As an analyst for several managers, occasionally you are asked to gather evidence to suit different agendas. Note that for simplicity, we ignore the specific size of a land or house, and you are only required to work with the median data (see Resources).
Your Task:
You will be allocated one suburb. Your task is prepare one statement, two separate reports and one short summary within an Excel document:
1. One statement of how the total cost of building a median-size house is determined within 50words.
2.One report for pros of your suburb to buy land and build a house for resale, with a maximum 100 words of explanatory
notes (not counting tables or graphs).
3.One report for cons of your suburb to buy a land and build a house for resale, with a maximum 100 words of explanatory notes (not counting tables or graphs).
4.A short summary of the overall suggestion: whether or not to buy, build and resale for your suburb, within 50 words.
Further documents details will be provided.
Background:
You are working for a buy-build-and-sale firm which is considering various options in and around a few suburbs in Victoria. As for a typical deal, the company buys an empty land on some selected suburb, builds a new house on the land, and then sells the house to investor(s). The combination of interest payments, opportunity costs, building costs, and taxes require the company to build and sell as quickly as possible, while maintaining a high-quality product. For simplicity, we only assume costs as empty land purchase and building of a new house, and revenues as resale of the new house (with land).
There is regular debate among senior managers about where is the best suburb to do their business. As an analyst for several managers, occasionally you are asked to gather evidence to suit different agendas. Note that for simplicity, we ignore the specific size of a land or house, and you are only required to work with the median data (see Resources).
Your Task:
You will be allocated one suburb. Your task is prepare one statement, two separate reports and one short summary within an Excel document:
1. One statement of how the total cost of building a median-size house is determined within 50words.
2.One report for pros of your suburb to buy land and build a house for resale, with a maximum 100 words of explanatory
notes (not counting tables or graphs).
3.One report for cons of your suburb to buy a land and build a house for resale, with a maximum 100 words of explanatory notes (not counting tables or graphs).
4.A short summary of the overall suggestion: whether or not to buy, build and resale for your suburb, within 50 words.
Further documents details will be provided.