Assignment #1, Excel Skills requirements ONLY HAVE TO DO FOR STRATFIELD AS A SUBURB NOT ALL OF THEM. Assignment #1 Details Background You are working for a real estate development firm which is considering various options in and around the Greater Sydney region. The company buys residential property and then builds or renovates as needed and then sells to owner-occupiers or investors. Typically, the company buys one of more adjacent stand-alone houses and then builds small-to-medium-sized apartment blocks. 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. There is regular debate among senior managers about where is the best place to invest. As an analyst for several managers occasionally you are asked to gather evidence to suit different agendas. Your Task You will be allocated one Local Government Area (LGA) Your task is prepare two separate short reports within an Excel document: Show that your LGA is a good place to build property for resale. Maximum 100 words of explanatory notes (not counting cover sheet, tables or graphs). Note: Your graph or graphs should tell your story - explanatory notes are only to help the reader understand how to read the graph, if needed, and to point out what the reader should learn from looking at the graph(s). Show that your LGA is not a good place to build property for resale. Maximum 100 words of explanatory notes (not counting cover sheet, tables or graphs). Note: Your graph or graphs should tell your story - explanatory notes are only to help the reader understand how to read the graph, if needed, and to point out what the reader should learn from looking at the graph(s). Resources Excel Spreadsheets Sales, Trend March 1991 – December 2016, Metropolitan LGAs may be downloaded from the NSW Department of Family and Community Services. The data show median home prices over time in a number of LGA's. Dollar values in these resources do not take account of inflation. You may decide that these prices should be adjusted for inflation using the Housing Inflation data in Table 5 or Table 9 of the Consumer Price Index data (Report 6401) from the Australian Bureau of Statistics (tip: hit the Downloads tab). For your own interest, you may want to access other publicly available data (e.g. ABS demographics) from the QuickStats website at the Australian Bureau of Statistics. Such data provide details of demographics based on the 2016 Census for LGAs and overall. Note that some census data may be out-of-date. Also, such demographic data are not needed for this analysis. Cautions Statistical data from the ABS are available at several levels of aggregation. LGAs represent a fairly large population. Collection districts may represent only several hundred people. Be sure that you are accessing the right level of aggregation for your analysis. Data presented in these Excel files are in their raw form. You will note that there are many redundant or additional columns, and there are missing values for those cases where data were not available, or where the number of transactions was too few to give a meaningful median measure. You will need to clean up the data before you begin your analysis. Confine your analysis to the price information contained in the Housing Price data. Additional information that might relate to specific properties (views, proximity to a park, etc.) are not applicable to this report. Similarly, additional information about the region itself (distance from the Central Business District, or distance from beaches or rivers, etc.) is likely to be contained already in the Price. Submission You should submit one Excel document only Include spreadsheets containing the data and graphs you used to prepare your reports.
Good content! i like the fast services! Writer has clearly done a good job! Thanks
MyAssignmenthelp.com boasts a team of talented and experienced thesis helper who are capable of providing best quality thesis help services. Our wide range of thesis writing services include assistance with writing and structuring top-quality thesis, help with research, topic selection help and editing and proofreading help. Students can get any of these services at cheap price. Despite charging cheap from student, our thesis writers never compromise with the quality. They efficiently answer students queries pertaining to can someone help me with my thesis paper.
Just share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Dear Expert Thank you for your service and support. The work was good, I got 72%.
Australia
WHAT AN FANTASTIC OUTCOME I RECEIVED!! My essay subject was very difficult with many parts! My MAH\'s expert NAILED IT!!!! thanks a million! I WILL BE BACK!
Australia
It was a very well done job. The writings are accurate and supported with reliable resources which were related to the assignment. It was done on time and quick service.
Australia
Hi, Received the grades for this assignment this morning. Good grades with some minor feedback. Professor is happy with the content, referencing and especially the way assignment was written. Please pass on my thanks and regards to the expert who did...
Australia