Msc Mid Q

Please use EXCEL 2007 Spread sheet and save it by your NAME and STUDENT ID on DESKTOP.

Answer any four (4) of the following five (5) questions.

1: Use PMT function in EXCEL 2007 to calculate the below problems

A: Calculate the monthly Payment on a 12 year $50,000 loan with an interest rate of 7%.

B: Calculate a 7 Year loan for $50,000 at 10% interest, with quarterly payments.

C: Calculate a 30 Year loan for $ for $200,000 at 6.5% interest, with monthly payments.

(5 Marks)

2: Prepare a salary sheet based on the given Data.

| Name |Grade |Basic |HRENT |TA |Medical |

|Lec-I |30000 |25% |10% |5% |0% |

|Lec-II |35000 |30% |15% |10% |5% |

|Prof-I |50000 |45% |25% |25% |7% |

|Prof-II |70000 |50% |30% |30% |10% |

(5 Marks)

3: Mr. Knight Rider wants to make profit of $67000, how much to sell? Solve this problem by using Goal-Seek analysis function on the given data.

|Income Statement of ABC Inc. |

|  | | | | |

|Customer Birthday List | | | | |

|Name |Shop |Birthday |Age |Category |

|REZWAN ISLAM b...