Question

In: Finance

Without using excel pleaseb) Maintenance records of a certain type of machine indicatethat the...

Maintenance records of a certain type of machine indicate that the first-year

maintenance cost of $80 increases by $30 per year over the 10-year replacement
period of the machine. Answer the following if the maintenance cost is considered to
occur at the end of the year and the firm’s interest rate is 12%:
a) What equal annual payments could the firm make to a service organization to carry out the maintenance for 20 machines?
b) How much additional could be paid for a new type of machine with the same service life that required no maintenance during its life?

Solutions

Expert Solution

a)

EMI = P*i*[(1+i)^n]/[{(1+i)^n}-1]

Where,

P = Principal = 1059.64

i = Interest Rate = 0.12

n = Number of periods = 10

Therefore, EMI = 1059.64*0.12*[(1+0.12)^10]/[{(1+0.12)^10}-1]

= 127.1568*(3.105848)/[3.105848-1] = $187.54

Equal Maintenance per year for 20 Machines = EMI as abive*20 = 187.54*20 = $3750.79

b)

Year Discounting Factor
[1/(1.12^year)]
Cash Flow
[Previous Year's Cash Flow]
PV of Cash Flows
(cash flow*discounting factor)
1 0.892857143 80 71.42857143
2 0.797193878 110 87.69132653
3 0.711780248 140 99.64923469
4 0.635518078 170 108.0380733
5 0.567426856 200 113.4853711
6 0.506631121 230 116.5251579
7 0.452349215 260 117.610796
8 0.403883228 290 117.1261361
9 0.360610025 320 115.395208
10 0.321973237 350 112.6906328
NPV =
Sum of PVs
1059.640508

Therefore,  Additional that can be paid for new machine = Net Present Valaue of All Years' Maintenance Costs of Old Machines = $1059.64


Related Solutions

Maintenance records of a certain type of machine indicate that the first-year maintenance cost of $80 increases by $30 per year over the 10-year replacement period of the machine.
Maintenance records of a certain type of machine indicate that the first-year maintenance cost of $80 increases by $30 per year over the 10-year replacement period of the machine. Answer the following if the maintenance cost is considered to occur at the end of the year and the firm’s interest rate is 12%: a) What equal annual payments could the firm make to a service organization to carry out the maintenance for 20 machines? b) How much additional could be paid for...
What is Mirr? how do you find it using excel without using excel formula? Below is...
What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $   (5,000,000.00) NWC $   (1,120,000.00) $      (150,000.00) $      (170,000.00) $      140,000.00 $   1,300,000.00 OCF $     9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $   (3,960,000.00) CF $ (36,120,000.00) $     8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...
The maintenance cost for a certain machine is 1500 TL per year for the first 5...
The maintenance cost for a certain machine is 1500 TL per year for the first 5 years (from n=1 to n=5), 2200 TL in year 6, and from year 7 until year 35 the maintenance cost per year increases 6% with respect to the amount of the previous year. At an interest rate of 8% per year, what is the equivalent equal payment series?
please write all formulas and show your work without using excel Using the information in Question...
please write all formulas and show your work without using excel Using the information in Question 1, what is the break-even market size for the project? Show your work, and round to the nearest unit. Refer to question 1: Consider a project with annual expected income based on approximately $125 million in revenue and approximately $77.5 million in total variable cost. You realize that both of these numbers are projected, and that your projections may be incorrect. Your boss wants...
How do we return the datatype of arguments without using type of in javascript
How do we return the datatype of arguments without using type of in javascript
A. The maintenance on a machine is expected to be $155 at the end of the...
A. The maintenance on a machine is expected to be $155 at the end of the first year, then increasing by $35 each year for the next 7years, what sum of money would need to be set aside now and pay the maintenance for the 8-year period ? Assume 10% interesrt. B. what is the uniform annual equivalent maintenance cost for the above machine ? compute equivalent for A for the maintenance cost. pls draw the cash flow and show...
Without using excel Quasar Tech Ltd is investing $6 million in new machinery that will produce...
Without using excel Quasar Tech Ltd is investing $6 million in new machinery that will produce the next-generation routers. Sales to its customers will amount to $1 750 000 for the next 3 years and then increase to $2.4 million for 3 more years. The project is expected to last 6 years and cost the company annually $898 620 (excluding depreciation). The machinery will be depreciated to zero by year 6 using the straight-line method. The company’s tax rate is...
using excel functions Complete the following without a table (round each calculation to the nearest cent...
using excel functions Complete the following without a table (round each calculation to the nearest cent as needed): 1. principal time rate of compounding interest   compounded NUMBER of periods compounded total amount Total interest $ 500   1 year 8% quarterly A. ? B. ? C.? Solve the previous problem by using compound value (FV). See Table 12.1. Lionel Rodgers deposits $7,000 in Victory Bank, which pays 4% interest compounded semiannually. How much will Lionel have in his account at the...
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail)...
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail) You are considering the purchase of a $500,000 home. You plan to take a 30-year fixed mortgage after making a 20% downpayment to avoid PMI. Payments are to be made monthly (at the end of the month) and the APR is 8%. What is the monthly payment? During what month does the principal portion first exceed the interest portion? Are you surprised by your...
Depreciation Problem: (8pts) ---- Please complete using Excel or by hand. A machine was purchased for...
Depreciation Problem: (8pts) ---- Please complete using Excel or by hand. A machine was purchased for $92,000 and had a depreciable life of five years and a depreciable salvage value of $5,000. Using the following depreciation methods; Straight Line, Sum-OfYears’ Digits, Double Declining Balance, and MACRS(with a 5 year property class): a. Create a depreciation schedule The owner has been offered to sell the machine in year 2 for $50,000.   b. Calculate if the company will see a gain or...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT