G16 X V A B C D E F G H K M N P O R Time Periods w Bank offer $0.00 120 132 144 156 168 180 192 Initial Investment ($50,000) 500,000 Loan Amount $1,500,000 750,000 Annual Interest Rate 1.00% Loan Amounts 1,000,000 Interest Rate(Monthly) 1,250,000 Number of Months(NPER) 120 1,500,000 10 Monthly Payment 11 12 PMT $4,500.00 PV 13 $500,000.00 14 Number of Periods3 4 Questions Marks Obtained 5 Saeed has finally found a Business-Loan that he has been looking for since a long time. He decided to take this loan and start his business. The bank offered him a flat 4.0% yearly interest rate irrespective of the duration and the amount he will take. Setup a worksheet that will show the monthly payments if you take a loan of SAR 6 500,000, 750,000, 1,000,000, 1,250,000 or 1,500,000 also to show the monthly payments if you want to pay it 7 in 120, 132, 144, 156, 168, 180 or 192 months. 8 In the "Business Loan" worksheet, answer all below questions: 9 10 1 In cell C7, compute the monthly interest rate for the house loan. 1 In cell C10, compute the monthly payment for the house loan of $1500,000, if he decides to take loan for 2 11 10 years. In range F4:LS, use two variable data table to find out the monthly payment you should pay based on 3 12 3 different loan amount and time periods Terms. In cell C14, find out the number of months required to pay back the loan of $500,000 (Cell C13) if you 13 4 decided to pay $4500 (Cell C12) as monthly payment for the whole period Make Scenarios for changing loan amount to 750,000, 1,000,000 and 1,500,000 USD and time period for 3 14 5 reimbursement of loan to 144, 180 and 192 months respectively. 15 6 Make summary out of these scenarios 1 16 0 17 18 19 20