answer these two questions using exel $.$Question $2$

Steven is the owner of a real estate investment company. He has identified four apartment

buildings at each one of the four locations: Amber Villa, Boustead Riverside, Crescent Court

and Dunkin Park. Steven has approached three banks $-$ Western Bank, Tokyo Bank and Hong

Kong Bank regarding financing. Because Steven has been a good client and has maintained a

high credit rating in the community, each bank is willing to consider providing all or part of

the mortgage loan needed on each property.

Each bank has set differing interest rates on each property $($rates are affected by the

neighbourhood of the apartment building, condition of the property, and desire by the

individual savings and loan to finance various size buildings$),$ and each bank has placed a

maximum credit ceiling on how much it will lend Steven in total. This information is

summarized in the table below.

Each apartment building is equally attractive as an investment. So$,$ Steven has decided to

purchase all four buildings at the lowest total payment of interest.

$($a$)$ Advice Steven from which banks he should borrow to purchase which buildings.

$($More than one loan can finance the same property$)$

$($b$)$ Asian Bank officer contacted Steven and offered a cash reward of $$20,000$ for any one

property he buys using Asian Bank loan. Advice Steven.

$(10$ Marks$)$