Answer Happy

Name: Student Number: Instructions This assignment (take-home quiz) is worth 15 points and it contains 2 problems. This is an individual assignment (no groups). Any signs of cheating will result in a zero score for this assignment and may result in an F grade in the class. Use Microsoft Excel, and make sure that your work is well-organized and presented neatly. Messy work will not receive the full mark even if the math is correct. - Print your name/student number, save the file as a PDF document or keep it as an excel, and upload it to eLearning (scanned copies will not be accepted, you can upload your spreadsheet work). The deadline for submission is at 11:55 pm on May 30th, 2022. Late submissions will receive a zero score. → Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 11%. The study period needs to be exactly 5 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram). Problem 2 After graduation, you just got hired by an engineering company and you were planning to take a loan in order to purchase a new car. Let's assume that the bank is willing to offer you a personal loan with an annual interest rate of 7% compounded yearly. The car price is 25,739 JD and you are capable to pay 5,400 JD per year. After how many years you will be able to pay back the loan with the accumulated interest (use a spreadsheet to answer this question) and draw the cash flow diagram?