In order to start a coffee business, the Manager took a 300K loan from the bank. He/she will have to pay 10K monthly for three years.

a-Calculate the effective interest rate (per year). SOLVE BY HAND NOT SPREADSHEET

b-If the coffee business makes a Revenue=19K/month and has an operational cost of 12K/Month, Calculate the PW if the study period is 5 years and the MARR is equal to 1.5% per month. Solve by either Spreadsheet or Hand,

Please Specify in which cells you put which formula.