Activity $5($extracted from Jan $2020$ Q$2)$

Bluemart Limited $($BL$)$ provides online grocery shopping and delivery in Singapore.

The company has been gaining market share with its fresh produce, friendly user$-$

interface and on$-$time delivery services.

Delivery service is currently outsourced to an external provider, and is expected to cost

$$250,000$ for the coming year. BL wants to have better control over delivery operations,

and hence, is considering investing in its own fleet of delivery vehicles. The useful life

of the vehicle fleet is expected to be five years, after which the fleet will be disposed.

The cost of the external provider is expected to rise $10$ per cent per annum over the useful

life of the vehicle fleet. The initial cost of the fleet is $$750,000.$ Additional costs are

estimated to be incurred over the next five years:

Driver's Costs, repairs & maintanence, Other Costs $($Respectively$)$

$($$$)($$$)($$$)$

Year $133,0008,000130,000$

Year $235,00013,000135,000$

Year $336,00015,000140,000$

Year $438,00016,000136,000$

Year $540,00018,000142,000$

Included in $$Other Costs$$ is depreciation expense. Depreciation is charged on a straight$-$

line basis. BL expects that the vehicle fleet to be sold for $$150,000$ at the end of year $5.$

BL has obtained a long$-$term loan to finance the project. Interest on the loan is at a fixed

rate of $12$ per cent per annum.

If the loan is not used for the acquisition of the vehicle fleet, there is a competing project

where the loan can be used for. The projected results for the competing project is as

follows:

Payback $=3$ years

Average accounting rate of return $=30\%$

Net present value $=$ $$140,000$

As funds are limited$,$ investment can only be made in one project.

Note: You can assume that the vehicle fleet will be purchased at the beginning of the

project, and all other expenditures will be incurred at the end of each relevant year.

Required:

$($a$)$ Prepare a table showing the net cash savings $($or losses$)$ that BL can expect over the useful life of investment in the vehicle fleet. $(5$ marks$)$

$($b$)$ Compute the following for the vehicle fleet investment:

$($i$)$ Payback period.

$($ii$)$ Average accounting rate of return.

$($iii$)$ Net present value.

$($Note: PV factors for $12\%$ are as follows: Year $1=0\mathrm{.}893$; Year $2=0\mathrm{.}797$; Year $3=0\mathrm{.}712$; Year $4=0\mathrm{.}636$; Year $5=0\mathrm{.}567$; the PV annuity factor for $12\%,5$ years $=3\mathrm{.}605)(14$ marks$)$

$($c$)$ Discuss in a short report to the investment manager of BL whether the funds from the loan should be invested in the vehicle fleet or the competing project. $(9$ marks$)$