Below is my calculation for the questions. Could you please perform your own calculation and verify its accuracy?

image.png

Answer

$0$ Year $01$ Year $02$ Year $03$ Year $04$ Year $05$

Sales $110,000\mathrm{.}00121,000\mathrm{.}00133,100\mathrm{.}00146,410\mathrm{.}00161,051\mathrm{.}00$

Cost

Variable Cost $82,000\mathrm{.}0081,400\mathrm{.}0089,540\mathrm{.}0098,494\mathrm{.}00108,343\mathrm{.}40119,177\mathrm{.}74$

Fixed Cost $12,400\mathrm{.}0013,640\mathrm{.}0015,004\mathrm{.}0016,504\mathrm{.}4018,154\mathrm{.}8419,970\mathrm{.}32$

Total Cost $94,400\mathrm{.}0095,040\mathrm{.}00104,544\mathrm{.}00114,998\mathrm{.}40126,498\mathrm{.}24139,148\mathrm{.}06$

Residual Value $13,000\mathrm{.}0010,000\mathrm{.}00$

Initial Investment $-100,000\mathrm{.}00$

Net Cash flow $-87,000\mathrm{.}0014,960\mathrm{.}0016,456\mathrm{.}0018,101\mathrm{.}6019,911\mathrm{.}7631,902\mathrm{.}94$

Discounting Factor $-10\%10\mathrm{.}909090\mathrm{.}826450\mathrm{.}751310\mathrm{.}683010\mathrm{.}62092$

NPV $-87,000\mathrm{.}0013,599\mathrm{.}9913,600\mathrm{.}0613,599\mathrm{.}9113,599\mathrm{.}9319,809\mathrm{.}17-12,790\mathrm{.}94$

Workings $01$

Current VC $82,000\mathrm{.}00$

Cost Saving $8,000\mathrm{.}00$

$74,000\mathrm{.}00$

Workings $02$

NBV of Current machine $13,000\mathrm{.}00$

No of years $5\mathrm{.}00$

$2,600\mathrm{.}00$Flex Star's bag$-$making division specializes in manufacturing plastic components for the small pet

food market. These components are produced in high$-$volume runs, with equipment often operating

around the clock for consecutive days to maintain production consistency. Additionally, the division

fulfills low$-$volume orders with unique specifications. One of the machines in this department

requires replacement. Currently valued at CAD$$13,000,$ the machine must be replaced due to

upcoming safety regulations. This machine produces Flat bottom bags of which incur fixed costs,

including depreciation, the relevant details of which are as follows:

Note that: All the fixed costs $($including depreciation$)$ are directly related to the production of Flat

bottom bag.

Projections indicate that current revenue and costs will increase $10\%$ each year for the next five

years, aligning with the expected lifespan of the new machine under review. Introducing this new

machine would reduce variable costs by CAD $$8,000$ for $A.$ Acquisition and installation costs for the

new machine are estimated at CAD $$100,000,$ with a $$10,000$ residual value after five years.

Company policy dictates straight$-$line depreciation for such machinery, with a cost of capital set at $10$

percent. Alex wanted to invest in this machine but was not certain about the best approach to

evaluate this investment.