Question

In: Finance

PLEASE SHOW WORKINGS ON EXCEL FM Corporation is considering either purchasing or leasing an asset that...

PLEASE SHOW WORKINGS ON EXCEL

FM Corporation is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning of years 1–5. Your company has a tax rate of 40 percent and can borrow at 10 percent from its bank.

(a) Recommend if your company should lease or purchase the asset?

(b) Compute the maximum lease payment FM Corporation would agree to pay?

Solutions

Expert Solution

Answer (A)

OPTION 1: PURCHASE OF MACHINE

PRESENT VALUE OF OUTFLOW ON PURCHASE OF MACHINERY = $1,000,000

Therefore in Option 1

Present Value of Net outflow = Purchase Price - Present value of Savings in Tax due to Depreciation

= 1,000,000-287,734.94    

= $ 712,265.06      

OPTION 2: LEASING OF MACHINE

Since in Purchase option Present Value of Net outflow is low therefore it is beneficial for company to purchase the Asset.

Answer (B)

Maximum Lease Payment = NET OUTFLOW IN PURCHASE OPTION / P.V. ANNUITY FACTOR AT 10%

                                      = $ 712,265.06 / 1+.09091+.8264+.7513+.6830+.6209    

                                      = $ 712,265.06 / 3.97251

                                    = $ 179,298.49


Related Solutions

Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an...
Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning...
PLEASE SHOW ANSWER WITHOUT USING EXCEL OR ANY SOFTWARE. NEED DETAILED WORKINGS OF THE ANSWER. PLEASE...
PLEASE SHOW ANSWER WITHOUT USING EXCEL OR ANY SOFTWARE. NEED DETAILED WORKINGS OF THE ANSWER. PLEASE NOTE NO EXCEL Conduct a test of hypothesis to determine whether the block of the treatment means differ. Using the .05 significance level: State the null and alternate hypothesis for treatments State the decision rule for treatments State the null and alternate hypothesis for blocks State the decision rule for blocks Compute SST, SSB SS total, and SSE Complete an ANOVA table Give your...
PLEASE SHOW ANSWER WITHOUT USING EXCEL OR ANY SOFTWARE. NEED DETAILED WORKINGS OF THE ANSWER. PLEASE...
PLEASE SHOW ANSWER WITHOUT USING EXCEL OR ANY SOFTWARE. NEED DETAILED WORKINGS OF THE ANSWER. PLEASE NOTE NO EXCEL The manager of a computer software company wishes to study the number of hours senior executives by type of industry spend at their desktop computers. The manager selected a sample of five executives from each of three industries. At the .05 significance level, can she conclude there is a difference in the mean number of hours spent per week by industry?...
Banana Inc. is considering either purchasing or leasing a $600,000 piece of specialized equipment. The equipment...
Banana Inc. is considering either purchasing or leasing a $600,000 piece of specialized equipment. The equipment has a life of 5 years, belongs in a 30% CCA class, and will have no residual value. The cost of debt is is 12% for this purchase. A lease on this equipment for 5 years is priced at $150,000 a year. Banana Inc.'s corporate tax rate is 34%. What is Banana Inc.'s break-even lease payment? a) $182,968 b) 170,802 c) $109,057 d) $133,677...
Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new...
Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new system. The old system has an annual operating and maintenance cost of $31,000, a remaining life of 8 years, and an estimated salvage value of $5,800 at that time. A new system can be purchased for $237,000; it will be worth $26,000 in 8 years; and it will have annual operating and maintenance costs of $19,000/year . If the new system is purchased, the...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
please show all workings step by step Question 1 M & M Printing is considering the...
please show all workings step by step Question 1 M & M Printing is considering the purchase of a new printing press. The cost of the press is $2 million. This outlay will be partially offset by the sale of an existing press. The old press has zero net book value, cost $1 million ten years ago and can be sold currently for $0.2 million before taxes. As a result of acquiring the new press, sales in each of the...
Explain the differences between purchasing an asset and leasing an asset. What are some "good" reasons...
Explain the differences between purchasing an asset and leasing an asset. What are some "good" reasons for opting to lease rather than purchase an asset? What are typical incremental cash flows, and how do you determine the net advantage to leasing
(IN EXCEL PLEASE/ With formulas shown) Engineering economics A firm is considering purchasing a machine that...
(IN EXCEL PLEASE/ With formulas shown) Engineering economics A firm is considering purchasing a machine that costs ​$65000. It will be used for six​ years, and the salvage value at that time is expected to be zero. The machine will save ​$35000 per year in​labor, but it will incur ​$12000 in operating and maintenance costs each year. The machine will be depreciated according to​ five-year MACRS. The​ firm's tax rate is 40%, and its​ after-tax MARR is 15%. Should the...
1. FERTILIZER NUTRIENTS (Please Use Excel and show screenshots :) ) A produce farmer is purchasing...
1. FERTILIZER NUTRIENTS (Please Use Excel and show screenshots :) ) A produce farmer is purchasing fertilizer containing three nutrients: nitrogen, phosphorus, and potassium. The farmer’s minimum weekly requirements are 240 units of nitrogen, 120 units of phosphorus, and 80 units of potassium. There are two popular blends of fertilizer on the market. Blend A costs $8.00 a bag, and contains 4 units of nitrogen, 6 units of phosphorus, and 4 units of potassium. Blend B costs $10.00 a bag,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT