Question

In: Finance

Q) A company XYZ plans to purchase a production line that costs annually 50,000 AED paid...

Q) A company XYZ plans to purchase a production line that costs annually 50,000 AED paid at end of each year for ten years. Starting the end of second year, the annual payment increases by amount of 5,000 AED over the 10 years period. If the interest rate is 10% answer the following questions

  1. What is the present worth of the annual amount?
  2. What is the present worth of the gradient payments?
  3. What is the total present worth of the payment?
  4. What is the equivalent annual payment?

Q)The numerical value of the factor (P/A, 4%, 18) Is Hint: example of answer input e.g. 3.3333

Solutions

Expert Solution

Annual payment = 50,000 AED; gradient payment = 5,000 AED (increasing every year from 2nd year onwards); interest rate (r) = 10%; time period (n) = 10 years

Using this data, we have:

Time period (n) Annual Payment
(AP)
Gradient Payment
(GP)
Total Payment P
(AP+GP)
Present worth of AP
(AP/(1+r)^n)
Present worth of GP
(GP/(1+r)^n)
Present worth of the annual amount
(P/(1+r)^n)
1 50,000 0 50,000 45,454.55 0.00 45,454.55
2 50,000 5,000 55,000 41,322.31 4,132.23 45,454.55
3 50,000 10,000 60,000 37,565.74 7,513.15 45,078.89
4 50,000 15,000 65,000 34,150.67 10,245.20 44,395.87
5 50,000 20,000 70,000 31,046.07 12,418.43 43,464.49
6 50,000 25,000 75,000 28,223.70 14,111.85 42,335.54
7 50,000 30,000 80,000 25,657.91 15,394.74 41,052.65
8 50,000 35,000 85,000 23,325.37 16,327.76 39,653.13
9 50,000 40,000 90,000 21,204.88 16,963.90 38,168.79
10 50,000 45,000 95,000 19,277.16 17,349.45 36,626.61
Total 307,228.36 114,456.71 421,685.07

a). Present worth of annual payment = 307,228.36 AED

b).  Present worth of gradient payment = 114,456.71 AED

c). Present worth of total payment = 421,685.07 AED

d). Equivalent annual payment can be calculated using the following formula:

NPV = present worth of total payment = 421,685.07 AED; r = 10% and n = 10

C = (10%*421,685.07)/(1-(1+10%)^-10)

= 421,68.51/0.61446

= 68,627.30 AED (Answer)


Related Solutions

Q) A company XYZ plans to purchase a production line that costs annually 5000 AED paid...
Q) A company XYZ plans to purchase a production line that costs annually 5000 AED paid at the end of each year for ten years. Starting the end of second year, the annual payment decreases by amount of 5% every for the 10 year period, for 10% interest rate, the total present worth is ? Q) Ahmed takes out a loan of AED 4228 for 5 years. After 5 years he will payback AED 8,400 to clear his debt. What...
If Company XYZ plans to launch a new production line, and in year 1, will have...
If Company XYZ plans to launch a new production line, and in year 1, will have sales revenue                     $10,000,000, operating cost is 70% of the sales revenue, depreciation is $2,000,000, and tax rate                   is 40%, what is the Company’s projected cash flow in year 1?                                                             b. If the Company’s launch of the new production line will cause the exit of an existing production line               that can generate $1,000,000 operating income before tax, how much will be the Company’s           projected...
1.      XYZ Company produces widgets. XYZ Company calculates the following costs for the production of 1...
1.      XYZ Company produces widgets. XYZ Company calculates the following costs for the production of 1 widget. Direct materials:           $250 Direct labor:                   $400 Variable overhead:      $125 Fixed overhead:            $200 Variable selling:            $50 Fixed selling:                  $35 Assuming that XYZ uses a 25% markup on the cost of producing 1 unit, calculate the sales price per unit charged by XYZ. a.      $812.50 b.      $1,325 c.       $848 d.      $1,218.75
C purchase XYZ Company stock several years ago for $50,000. Unfortunately, the stock had declined in...
C purchase XYZ Company stock several years ago for $50,000. Unfortunately, the stock had declined in value. Therefore, C decided to sell the stock on December 15, 2020 for $35,000, incurring a loss of ($15,000). C had other gains of $40,000 in 2020 and felt he would like to offset those gains with the loss on XYZ Company stock. However, after reading some very favorable news about XYZ Company in early January, 2021, C decided to buy back XYZ Company...
XYZ Medical Ltd a Melbourne based company enters into a non-cancellable purchase commitment of US$50,000 with...
XYZ Medical Ltd a Melbourne based company enters into a non-cancellable purchase commitment of US$50,000 with an American supplier on 1 April 2020 to buy the face masks in a bulk for medical staff. These face masks are to be shipped on the 1st of May 2020. The amount owing on the purchase is payable on 31 July 2020. XYZ Ltd observed that exchange rate is very volatile due to the current trade war between America and China. XYZ decided...
C purchase XYZ Company stock several years ago for $50,000. Unfortunately, the stock had declined in...
C purchase XYZ Company stock several years ago for $50,000. Unfortunately, the stock had declined in value. Therefore, C decided to sell the stock on December 15, 2020 for $35,000, incurring a loss of ($15,000). C had other gains of $40,000 in 2020 and felt he would like to offset those gains with the loss on XYZ Company stock. However, after reading some very favorable news about XYZ Company in early January, 2021, C decided to buy back XYZ Company...
On June 1, 2018, XYZ Company paid $150,000 to purchase some equipment. The equipment was assigned...
On June 1, 2018, XYZ Company paid $150,000 to purchase some equipment. The equipment was assigned a useful life of 20 years and was to be depreciated using the straight-line method. On October 31, 2022, XYZ Company sold the equipment for $102,970 cash. XYZ Company recorded a loss on the sale equal to $14,965. Calculate the residual value that was assigned to the equipment.
On June 1, 2016, XYZ Company paid $375,000 to purchase land, a building, and some equipment....
On June 1, 2016, XYZ Company paid $375,000 to purchase land, a building, and some equipment. The market value of these assets on that date were: land $68,000; building $220,000; equipment $112,000. The equipment was assigned a useful life of 15 years and a $6,000 residual value. The equipment will be depreciated using the straight-line method. On November 30, 2023, XYZ Company sold the equipment for $39,300 cash. Calculate the amount of the loss recorded on the sale of the...
On June 1, 2016, XYZ Company paid $375,000 to purchase land, a building, and some equipment....
On June 1, 2016, XYZ Company paid $375,000 to purchase land, a building, and some equipment. The market value of these assets on that date were: land $68,000; building $220,000; equipment $112,000. The equipment was assigned a useful life of 15 years and a $6,000 residual value. The equipment will be depreciated using the straight-line method. On November 30, 2023, XYZ Company sold the equipment for $39,300 cash. Calculate the amount of the loss recorded on the sale of the...
On January 1, 2018, XYZ Company paid $380,000 to purchase land, building, and equipment. The market...
On January 1, 2018, XYZ Company paid $380,000 to purchase land, building, and equipment. The market values of these assets on that date were: land $60,000; building $200,000; equipment $140,000. Before the property could be used, XYZ Company had to spend $5,000 to put the equipment in working order. The building was assigned a useful life of 20 years with a $4,000 salvage value. The building will be depreciated using the straight-line method. On October 1, 2028, XYZ Company sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT