For the selection of subcontractors; we have to calculate the present value (PV) of the prices offered by them but first we have to calculate effective annual rate
For monthly compounding, effective annual rate (EAR) = (1 + r/m) ^m – 1
Where, r = 12% and m = 12 months
= (1 + 12%/12) ^12 - 1
= (1 + 1%) ^12 - 1
= 0.1268 or 12.68%
Now,
PV of the price of Subcontractor A = 50% of $40000 now + 50% of $40000 after one year
= $20,000 + $20,000/ (1+12.68%) ^1
= $20,000 + $17,748.98
=$37,748.98
PV of the price of Subcontractor B = 30% of $42000 in 6-months + 70% of $42000 after one year
= $12,600/ (1+12.68%/2) + $29,400/ (1+12.68%) ^1
= $11,848.65 + $26,091.01
= $37,939.65
PV of the price of Subcontractor C = 75% of $39000 now + 25% of $39000 after one year
= $29,250 + $9,750/ (1+12.68%) ^1
= $29,250 + $8,652.63
=$37,875.63
The Subcontractor A has lowest cost therefore they should be selected
FV Subcontractor Selection PV = 7+ • A General Contractor (GC) obtained bids from three local...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...
this is all the information given
Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet reached their peak earning years. Jeff is a general manager of a jewelry manufacturer in Providence, RI while Mary teaches at the local elementary school in the town of Tiverton, RI. The family needs both incomes to meet their...