I'm not sure with my payment for each option in my assignment. i would like to know how i calculate each financial option's payment, i would like to get those figure if it is possible thank you

FINM2401\tFinancial\tManagement,\tSemester\t2\t2016 FINM2401\tFinancial\tManagement,\tSemester\t2\t2016 Team\tProject Assignment\tdue:\t11:59pm\ton\t9th\tOctober\t2016.\tSubmit\telectronically\ton\tBlackboard\t-\tone assignment\tper\tgroup. Group:\tThis\tis\ta\tgroup\tassignment.\tYour\tgroup\tshould\tcontain\t3-4\tstudents. Facts: You\thave\tjust\tsecured\tyour\tfirst\tjob\tsince\tyou\tgraduated\tfrom\tUQ\tBusiness\tSchool\t3\tmonths ago.\tThe\thousing\tmarket\tis\tpretty\tgood\tand\tyou\tdecide\tto\tjump\tin\tnow.\tSince\tyou\tare\ta\tfresh graduate,\tyou\tdo\tnot\twant\tto\tspend\ttoo\tmuch\ton\tyour\tfirst\tproperty.\tYou\thave\tyou\teyes\ton a one-bedroom apartment in Brisbane, priced approximately $475,000. Your training at UQBS has prepared you well for life after graduation and you are going to use your knowledge from FINM2401 Financial Management to assess different finance options as shown\tin\tbelow: Fixed-rate\tMortgage\tOption: ABC\tBank\toffers\ta\tmortgage\twith\ta\tdown\tpayment\tof\t$95,000 (paid on the day of purchase of the apartment) and the balance is financed by a 5% p.a. fixed interest (compounded monthly) home loan with a term of 30 years with monthly payments\t(first\tpayment\tpaid\tone\tmonth\tafter\tyou\tbuy\tyour\tapartment).\tThis\toffer\tincludes $3,000\tin\tloan\tset\tup\tfees\tthat\tmust\tbe\tpaid\tin\tcash\ton\tthe\tdate\tof\tpurchase. Floating-rate Mortgage Option: ABC Bank offers a mortgage with a down payment of $100,000\t(paid\ton\tthe\tday\tof\tpurchase\tof\tthe\tapartment)\tand\tthe\tbalance\tfinanced\tby\ta\t4.5% p.a.\tfixed\tinterest\t(compounded\tquarterly)\tmortgage\twith\ta\tterm\tof\t20\tyears\twith\tquarterly payments\t(first\tpayment\tis\tpaid\ton\tthe\tday\tof\tpurchase\tof\tthe\tapartment).\tUnfortunately, this fixed interest rate will last only two years and then the rate will be variable for the remainder of the mortgage. ABC Bank estimates that the variable rate will be 5.5% p.a. (compounded\tquarterly)\tat\tthe\tbeginning\tof\tyear\t3.\tFor\tthe\tpurpose\tof\tyour\tcalculation\tthis variable rate is assumed to remain constant over the remaining life of the mortgage. Application\tfees\tfor\tthis\tloan\tare\t$2,000,\twhich\tmust\tbe\tpaid\tin\tcash\ton\tthe\tdate\tof\tpurchase. Interest\tOnly\tOption:\tABC\tBank\talso\toffers\tyou\tan\tinterest\tonly\toption.\tThis\toption\tmight\tbe interesting\tas\tyou\tjust\tgot\tyour\tfirst\tjob\tand\tyou\tdo\tnot\twant\tto\tspend\tmost\tof\tyour\tincome on\trepaying\tthe\tmortgage.\tYou\twill\tbe\tpaying\tonly\tinterest\tfor\tthe\tfirst\tfive\tyears,\tafter\tthat you will be paying interest and the principle for the remaining 25 years. You would make monthly\tpayments\tover\tthe\tfull\tlife\tof\tthe\tloan.\tA\tdown\tpayment\tof\t$95,000\tis\tto\tbe\tpaid\ton the\tday\tof\tpurchase\tand\tthe\tinterest\trate\tis\tfixed\tat\t5%\tp.a.\t(compounded\tmonthly). 1 FINM2401\tFinancial\tManagement,\tSemester\t2\t2016 Off-the-Plan\tOption:\tA\treal-estate\tagent\ttold\tyou\tthat\tas\ta\tfirst-time\thome\towner,\tyou\twill be eligible to receive a first home owner's grant of $20,000 if you buy a brand new apartment.\tLuckily,\tyou\thave\tfound\ta\tdevelopment\tproject\toffering\tnew\tapartment\tthat\tis almost\tthe\tsame\tas\tthe\tsecond-hand\tone\tthat\tyou\twere\tconsidering\tto\tbuy\tand\talso\tpriced at\t$475,000. However,\tthis\tnew\tproperty\tis\tcurrently\tselling\tas\t'off-the-plan'\t('off\tthe\tplan' simply means a property that hasn't been built yet). It will be exactly 2 years before your apartment\tsettles.\tFor\tan\toff\tthe\tplan\tpurchase,\tyou\twill\tbe\tpaying\t10%\tdeposit\twhen\tyou sign\tthe\tcontract\twith\ta\tdeveloper\t(you\twill\tsign\tit\ttoday)\tand\tthe\tremaining\tbalance\twill\tdue on\tthe\tsettlement\tdate.\tYour\t10%\tdeposit\twith\tthe\tdeveloper\twill\tbe\tearning\tan\tinterest\tat\t4% p.a. (compounded monthly). Let's assume on the settlement date, you decide to pay another 10% of the purchase price. The $20,000 grant will be credited to your saving account\ton\tthe\tsettlement\tdate\t(for\teasy\tcalculation\tpurposes)\tand\tyou\twill\tuse\tit\tto\tpayoff your mortgage. The remaining balance will be financed by the mortgage, where the first repayment\thappens\tone\tmonth\tafter\tthe\tsettlement\tdate.\tThe\tapplication\tfee\tfor\tthis\tloan\tis $3,000\tin\tcash\ton\tthe\tsettlement\tdate.\tYou\twill\ttake\tout\ta\t30-year\tmortgage\tpaying\ta\tfixed at 5% p.a. (compounded monthly). Meanwhile, you will be renting a unit before your apartment\tis\tsettled.\tThe\tmonthly\texpense\tfor\trenting\tis\t$900\t(due\tat\tthe\tbeginning\tof\tevery month,\tbeginning\ttoday). Borrowing\tand\tLending\tRate:\tTo\tfacilitate\tyour\tanalysis,\tassume\tthat\tyour\tbank\tallows\tyou to\tlend\t(and\tborrow)\tat\ta\trate\tof\t4%\tp.a.,\tcompounded\tdaily. Required: 1. Calculate\ta)\tthe\tmonthly\tpayment\ton\tFixed-rate\tMortgage\tOption\tloan,\tb)\tboth\tsets\tof quarterly payments on Floating-rate Option, c) both sets of monthly payments on Interest\tOnly\tOption\tand\td)\tthe\tmonthly\tpayment\ton\tthe\tmortgage\tshould\tyou\tdecide\tto purchase\toff-the-plan. 2. Prepare excel worksheets with the complete payment schedules for all four financing deals. The payment schedules should show the amount and timing of all payments. Graph\tthe\tInterest\tand\tPrincipal\tamounts\tout\tof\tthe\tpayments\tacross\ttime,\tin\teach\tcase. (Hint:\tuse\tseparate\texcel\tsheet\tfor\teach\toption) 3. a) Rank these financing options in order of attractiveness using the TWO valuation methods: (1) Internal Rate of Return (IRR), and (2) Net Present Value (NPV). (Hint: Think about handling interest rates with different compounding frequency, fees, and down\tpayments). b)\tImagine\tyour\tinvestment\taccount\tnow\tpays\t7%\tp.a.,\t5%\tp.a.,\t3%\tp.a.,\tor\t0%\tp.a.\t(all compounded\tdaily).\tProvide\tthe\trankings\tin\teach\tof\tthe\tscenarios\taccordingly. 2 FINM2401\tFinancial\tManagement,\tSemester\t2\t2016 4.\tPrepare\ta\ttyped\tsummary,\tdiscuss\tthe\tfollowing: a)\tBased\ton\tyour\tranking\tof\tthe\tfour\talternatives\tin\tPart\t3(a),\tdiscuss\tthe\tmost\tviable financial arrangement for you. Be sure to draw upon the financial knowledge you have learnt so far in this course when making your decision. NOTE: Your ranking should\tinclude\ta\tdiscussion\tof\tthe\tvaluation\tmethods.\tYou\tshould\talso\texplain why you\tchose\ta\tparticular\tmethod.\tThe\tdiscussion\tshould\tnot\tbe\tmore\tthan\t400\twords. b) Compare to your decision in Part 3(a), does your final decision change with different\tinterest\trates\tin\t3(b)?\tDiscuss\tbriefly\twhy\tor\twhy\tnot\tyour\tfinal\tdecision\twill change.\tThe\tdiscussion\tshould\tnot\tbe\tmore\tthan\t200\twords. Mark\tAllocation: Part\t1 Part\t2 Part\t3 Part\t4 Total Payment\tunder\tFixed\tRate\tMortgage\tOption Payment\tunder\tFloating\tRate\tMortgage\tOption Payment\tunder\tInterest\tOnly\tOption Payment\tunder\tOff-the-Plan\tOption Payment\tschedule\tand\tGraphs\tfor\tFixed\tRate\tMortgage\tOption Payment\tschedule\tand\tGraphs\tfor\tFloating\tRate\tMortgage\tOption Payment\tschedule\tand\tGraphs\tfor\tInterest\tOnly\tOption Payment\tschedule\tand\tGraphs\tfor\tOff-the-Plan\tOption Ranking\tComputation\tusing\tNPV\tand\tIRR Ranking\tunder\tdifferent\tscenarios\tusing\tNPV\tand\tIRR Discussion Presentation 5 10 10 10 5 10 10 10 20 20 35 5 150 Additional\tNotes: Your\tExcel\tfile\tshould\tinclude\tall\tworkings,\tcalculations,\tschedules\tof\tpayments,\tand graphs.\tFormulas\tfor\tthe\tcalculations\tshould\thave\tcell\treferences\twherever\tpossible. If you have computed a number incorrectly and just typed that number into the spreadsheet (or typed a formula using numbers when cell references could have been used), you will not receive partial credit for any portion of you computation that\tis\tcorrect. The\tWord\tlimit\tis\tfirm.\tOnly\tthe\tfirst\t400\twords\tfor\tQ4(a)\tand\t200\twords\tfor\tQ4(b) in your written response will be read. Marks will not be awarded after the word limit\tthreshold,\teven\tif\tyou\tprovide\tthe\tcorrect\tanswer. 3 FINM2401\tFinancial\tManagement,\tSemester\t2\t2016 NOTE:\tYou\tmust\tlist\tthe\tactual\tword\tcount\ton\tyour\tpdf\tfile.\tIf\tnot,\t1\tpoints\tin\tyour Presentation\tallocated\tmarks\twill\tbe\tdeducted. Final\tSubmission: Teams should submit their entire assignment (ONE SUBMISSION PER TEAM) by attaching TWO\tfiles: an Excel file containing the answers for Part 1, 2, and 3 on BLACKBOARD TEAM PROJECT (Name\tthe\tfile\t\"Assignment_FINM2401_TeamXXX.xlsx\"\twhere\txxx\tis\tyour team's\tnumber); and a pdf with the answer to Part 4 on TURNITIN TEAM PROJECT (Name the file \"Assignment_FINM2401_TeamXXX.pdf\"). NOTE: Please\tmake\tsure\tthat\tonly\tONE\tmember\tof\tyour\tteam\tsubmits\tthrough\tTurnitin.\tIf more than one team member submits the answer, Turnitin will treat it as plagiarism. You\thave\ta\tmaximum\t5\tattempts\ton\tsubmission,\tbut\tonly\tyour\tlast\tsubmission\twill be\tgraded. Each team member needs to submit the Peers Evaluation Form to get the assignment\tscore. 4