BUSINESS STATISTICS: Spreadsheet Modeling for Business

Question 1 Not yet answered In the picture below we have a cashflow for various years. In Year=0 a $100 deposit is paid then in the succeeding years a return of $10 is received with the initial deposit returned in Year=3. The internal rate of return (IRR) of this cashflow is 10%. Recreate this cashflow in a spreadsheet. Use Excel's Goal Seek to calculate how much the initial deposit in Year=0 should be currently $100) such that the IRR is equal to 14%. (Report the number to 2 decimal places and include units) Marked out of 1.00 B P Flag A 1 Year 2 3 question Cashflow 0 -$100.00 1 $10.00 2 $10.00 3 $110.00 4 5 6 7 IRR =IRR(B2:35) IRR(values, (guess]) 8 Answer: Question 2 Not yet The business problem addressed is how many apartments a property developer should build on a piece of land that they have purchased. In the data table below we have the value of variables costs of producing a home along the first column ($200,000, $300,000, etc.) and along the first row we have the number of apartments that the developer builds (5, 10, etc.). The values in the data table are their profits conditional on a certain variable cost and a certain number of apartments built. If variables costs are $250,000 then what number of apartments maximises profit according to the data table? answered Marked out of 1.00 p Flag question $2,600,000 5 10 15 20 25 30 200000 $1,225,000 $2,900,000 $4,025,000 $4,600,000 $4,625,000 $ 4,100,000 250000 $ 975,000 $2,400,000 $3,275,000 $3,600,000 $3,375,000 $ 2,600,000 300000 $ 725,000 $1,900,000 $2,525,000 $2,600,000 $2,125,000 $ 1,100,000 350000 $ 475,000 $1,400,000 $1,775,000 $1,600,000 $ 875,000 $ (400,000) 400000 $ 225,000 $ 900,000 $1,025,000 $ 600,000 $ (375,000) $(1,900,000) Answer: Question 3 True or False. Excel's Data Table function undertakes constrained optimisation which shows how a function can be maximised or minimised subject to constraints. Not yet answered Select one: Marked out of 1.00 O True P Flag question O False Question 4 Not yet answered The business problem addressed is how many apartments a property developer should build on a piece of land that they have purchased. In the data table below we have the value of variables costs of producing a home along the first column ($200,000, $300,000, etc.) and along the first row we have the number of apartments that the developer builds (5, 10, etc.). The values in the data table are their profits conditional on a certain variable cost and a certain number of apartments built. If variables costs are $350,000 then what number of apartments maximises profit according to the data table? Marked out of 1.00 Flag question $2,600,000 5 10 15 20 25 30 200000 $1,225,000 $2,900,000 $4,025,000 $4,600,000 $4,625,000 $ 4,100,000 250000 $ 975,000 $2,400,000 $3,275,000 $3,600,000 $3,375,000 $ 2,600,000 300000 $ 725,000 $1,900,000 $2,525,000 $2,600,000 $2,125,000 $ 1,100,000 350000 $ 475,000 $1,400,000 $1,775,000 $1,600,000 $ 875,000 $ (400,000) 400000 $225,000 $ 900,000 $1,025,000 $ 600,000 $ (375,000) $(1,900,000)