Question

In: Accounting

The Asset Privatization Trust had put up for sale a machine tools manufacturing plant. There were...

The Asset Privatization Trust had put up for sale a machine tools manufacturing plant. There were 2 bidders with the following proposals: (1) Bidder "A" offered P10M, payable 20% down payment, the balance payable P1M annually for 8 years. (2) O Bidder "B" offered P9M, payable P2 M down payment, the balance payable P0.5M semi-annually for 7 years. Which bid is more beneficial to APT and by how much is the difference if money is worth 10% effective? Show by

Solutions

Expert Solution

We need to calculate the present values of both proposals in order to find out a more beneficial one.

As both bidders are ready to pay down payment and equal annuities, we can use the present value of annuities formula to find out the present value of installments.

PV = PMT * (1-(1/(1+rn)/r)

Where PV is the total present value of annuities

PMT = Annuity amount

r = Interest or discount rate

n = No. of payments

Bidder A

Present value of Down Payment(20% of Total Bid) = P2,000,000

The present value of eight annuities of P1,000,000

= 1,000,000 * (1-(1/(1+0.108))/0.10

=1,000,000*(1-(1/2.143589))/0.10

=1,000,000*(1-(0.466507))/0.10

=1,000,000*0.533493/0.10

=1,000,000*5.334926

= P 5,334,926

Total Present Value of proposal 1 = P2,000,000 + P5,334,926 = P7,334,926

Bidder 2

Present value of Down Payment = P2,000,000

The present value of Fourteen annuities of P500,000 paid semi annually, means paid in 14 payments.

Here r = 0.10/2 = 0.05 for semi annual period

n = 14

= 500,000 * (1-(1/(1+0.0514))/0.05

= 500,000 * (1-(1/1.97993)/0.05

= 500,000 * (1-0.505068)/0.05

= 500,000 * 0.494932/0.05

= 500,000 * 9.898641

= P4,949,320

Total Present Value of proposal 2 = P2,000,000 + P4,949,320 = P6,949,320

Bidder A's proposal exceeds Bidder B's proposal by P385,606 (P7,334,926 - P6,949,320) and Bid A is more beneficial to APT.

Present Values of Annuities can also arrive by using the PV function in Excel.

Bidder A:

=PV(10%,8,-1000000,0,0)

=

P5,334,926.20

Add to this Down payment of P2,000,000 to arrive at total value.

Bidder B:

=PV(10%/2,14,-500000,0,0)

P4,949,320.47

Add to this Down payment of P2,000,000 to arrive at the total value.


Related Solutions

The Asset Privatization Trust had put up for sale a machine tools manufacturing plant. There were...
The Asset Privatization Trust had put up for sale a machine tools manufacturing plant. There were 2 bidders with the following proposals: (1) Bidder "A" offered P10M, payable 20% down payment, the balance payable P1M annually for 8 years. (2) O Bidder "B" offered P9M, payable P2 M down payment, the balance payable P0.5M semi-annually for 7 years. Which bid is more beneficial to APT and by how much is the difference if money is worth 10% effective? Show by
Triple J Construction Firm had put up for sale of some of their heavy equipments for...
Triple J Construction Firm had put up for sale of some of their heavy equipments for construction works. There were two interested buyers submitting their respective bids for the heavy equipments. The bids are as follows: Buyer A offers P10,000,000 payable 20% downpayment, the balance payable P1,000,000 annually for 8 years. Buyer B offers P9,000,000 payable P2,000,000 down payment, the balance payable P500,000 semi-annually for 7 years. How much is the difference between the two bids if money is worth...
Sale of Plant Asset Lone Pine Company has a machine that originally cost $60,000. Depreciation has...
Sale of Plant Asset Lone Pine Company has a machine that originally cost $60,000. Depreciation has been recorded for four years using the straight-line method, with a $5,000 estimated salvage value at the end of an expected ten-year life. After recording depreciation at the end of four years, Lone Pine sells the machine. Prepare the journal entry to record the machine’s sale for (Round to the nearest dollar): a. $39,000 cash b. $38,000 cash c. $28,000 cash
E 9-7A. Sale of Plant Asset Raine Company has a machine that originally cost $58,000.  Depreciation has...
E 9-7A. Sale of Plant Asset Raine Company has a machine that originally cost $58,000.  Depreciation has been recorded for four years using the straight-line method, with a $5,000 estimated salvage value at the end of an expected ten-year life.  After recording depreciation at the end of four years, Raine sells the machine.  Prepare the journal entry to record the machine's sale for: a. $37,000 cash b. $36,800 cash c. $28,000 cash Debit Account Credit Account Debit Amount Credit Amount a. Debit Account...
A man put up $10,000 as earnest money on a property for sale. The next day,...
A man put up $10,000 as earnest money on a property for sale. The next day, he needed the money back and attempted to cancel his offer. Which of the following is true? He can get out of the offer because he has a three day right of rescission The decision would be entirely up to the broker He can get out of the offer because of the six day right of rescission He would have to revoke the offer...
Macon Inc. is looking at setting up a manufacturing plant in Kirksville. This will be a...
Macon Inc. is looking at setting up a manufacturing plant in Kirksville. This will be a 6-year project. The company bought the land in Kirksville last year for $1.5 million in anticipation of using it as a warehouse. The land is now appraised for $1.7 million after-tax. In 6 years, the after-tax value of the land is estimated for $2 million. The plant and equipment will cost $9.3 million to build and will be depreciated straight-line to zero over the...
A manufacturing plant bought a new machine to package its product. After some testing, the plant...
A manufacturing plant bought a new machine to package its product. After some testing, the plant supervisor decided that the packages needed about 300 packing peanuts to keep the product safe. She set the new machine to dispense the peanuts into each box but wanted to test to make sure the machine was operating correctly. She ran the machine 20 times and counted the number of packing peanuts dispensed. The plant conducts a one-mean hypothesis at the 5% significance level,...
Assume that an investor has a manufacturing plant that produces automotive spare parts. The sale price...
Assume that an investor has a manufacturing plant that produces automotive spare parts. The sale price of the part is 18 $/unit. The annual fixed cost of the plant is $1,500,000. Unit variable labor cost is 4 $/unit, unit variable material cost 3 $/unit, unit variable overhead cost 1 $/unit. a )How many units should be produced to start making profit (X)? b) How many units should be produced to make $1000,000 profit (Y)? a. X= 200000, Y= 325000 b....
In deciding whether or not to set up a new manufacturing plant, analysts for a popcorn...
In deciding whether or not to set up a new manufacturing plant, analysts for a popcorn company have decided that a linear function is a reasonable estimation for the total cost C(x) in dollars to produce x bags of microwave popcorn. They estimate the cost to produce 10,000 bags as $5290 and the cost to produce 15,000 bags as $7570 Find the marginal cost of the bags of microwave popcorn to be produced in this plant.
Sale of Plant Asset Shannon Company has a equipment that originally cost $68,000. Depreciation has been...
Sale of Plant Asset Shannon Company has a equipment that originally cost $68,000. Depreciation has been recorded for six years using the straight-line method, with a $9,000 estimated salvage value at the end of an expected eight-year life. After recording depreciation at the end of six years, Shannon sells the equipment. Prepare the journal entry to record the equipment’s sale for (Round to the nearest dollar): a. $30,000 cash b. $23,750 cash c. $21,000 cash General Journal Date Description Debit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT