Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers to operate their businesses. Instead of renting the space to the customers, PLL sells

the units to them under Strata Title. PLL needs to determine the right selling prices which allows it to maximise profit while attracting many buyers. This assignment requires you to practise principles of correct spreadsheet construction and design to help PLL to improve its decision making to meet its business challenges. Note: you must follow the information given in this TMA case and ignore other rules and regulations concerning property sales and bank loans. Mall Traffic, measured by the number of visitors-per-day, is often used as a variable to predict the occupants' business viability. PLL has collected the following information on mall traffic and selling price per square meter of four existing malls. Note: The Selling Price is valid only for units with areas between 50 to 200 square meters. Record how Selling Price changes with Mall Traffic by creating a scatter plot with a Trend Line and equation shown, assuming a linear relationship between the variables. PLL has completed building three properties with estimated mall traffic as shown below. The selling price has yet to be decided. Using the TRENDLINE that you have computed above, compose a spreadsheet model that will allow PLL to determine the Selling Price for each of the three properties by using Excel function(s).(0 marks) To attract customers to purchase larger units, PLL provides discounts as shown below: For example, a unit with 180 square meters will have the discount = (100 sq. meters *0% of selling price per sq. meter) + (50 sq. meters * 5% of selling price per sq. meter)+ (30 sq. meter * 10% of selling price per sq. meter) The data is only valid for the units with floor area between 50 square meters (the smallest unit) to 200 square meters (the largest unit). PLL requires the customers to pay at least 10% of the Selling Price as down payment.It has tied up with Alliance Business Bank (ABB) to provide loans to customers for the remaining amount. ABB allows the customers to re-pay the loan in equal installments(with interest) at the end of each month for up to 20 years. Construct a spreadsheet model as shown below that will help PLL's customers tocalculate the monthly payment to the bank by entering data into the shaded cells. Allnon-shaded cells must contain Excel formulae without being simply linked to anothercell. Note: To illustrate your skill in Excel Modelling with good practices, you shalldocument any use of good Excel functions or features to make your model resilient todata entry errors. Cozy Eatery, a F&B company, has purchased a 175-square metre unit at Tuas Square.The owner intends to put 13% down payment and pay the loan over 16 years. ABB willcharge the loan at annual interest rate of 1.5%. Use the model to calculate Cozy Eatery'smonthly payment to the bank. Demonstrate in a Data Table how the Monthly Payment will be affected by the"Number of pay back years" and “Down payment (% of Selling Price)". There shall be5 rows at increment of 1 year per row and 5 columns at increment of 1% per column. Cozy Eatery's owner wants to keep the monthly payment just below $15,000. Identifythe optimal combination of percentage of down payment and number of years ofpayment to reach this target. You shall highlight any special or advanced features in your models in Q1(a) to Q1(c).