(Answered) Using excelkaiser permanente must install a new 15 million

Finance

USING EXCEL

Kaiser Permanente must install a new $1.5 million computer to track patient records in its multiple service areas. It plans to use the computer for only three years, at which time a brand new system will be acquired that will handle both billing and patient records. The company can obtain a 10 percent bank loan to buy the computer or it can lease the computer for three years. Assume that the following facts apply to the decision:

-The computer falls into the three-year class for tax depreciation, so the MACRS allowances are 0.33, 0.45, 0.15, and 0.07 in Years 1 through 4, respectively.

-The company's marginal tax rate is 34 percent.

-Tentative lease terms call for payments of $500,000 at the end of each year.

-The best estimate for the value of the computer after three years of wear and tear is $500,000.

What are the NAL and IRR of the lease?

Should the computer system be purchased?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92405816
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Prokter and gamble pg has historically maintained a

Prokter and Gamble (PG) has historically maintained a debt-to-equity ratio (D/E) of approximately 0.3. Its cost of equity is 7.5% and it can borrow at 4.3%. PG's tax rate is 40%. PG believes it can increase debt without ...

Company has been growing at a rate of 10 per year and you

Company has been growing at a rate of 10% per year, and you expect this growth rate in earnings and dividends to continue for another 3 years. if the discount rate is 25% and the steady growth rate after 3 years is 2%, w ...

Question - in an article on edmunds website called

Question - In an article on Edmunds website called "Strategies for Smart Car Buying," Philip Reed highlights the need to focus on resale value. After 3 years, some cars are worth 55% of their original value, some only 20 ...

Bond a is a 1-year zero-coupon bond bond b is a 2-year

Bond A is a 1-year zero-coupon bond. Bond B is a 2-year zero-coupon bond. Bond C is a 2-year 10% coupon bond that pays annually. The yield to maturity (annually compounded) on bond A is 10%, and the price of bond B is $8 ...

Abc company writes 39 checks a day for an average amount of

ABC Company writes 39 checks a day for an average amount of $1438 each. These checks generally clear the bank in 3 days. In addition, the firm generally receives an average of $5636 a day in checks that are deposited imm ...

What is the corporate bond market and what are key

What is the Corporate Bond Market, and what are key differences between the bond and stock markets? What is A Government Bond Market?

Question - robert gillman an equity research analyst at

Question - Robert gillman, an equity research analyst at Gillman Advisors, believes in efficient markets, He has been following the mining industry for the past 10 years and needs to determine the constant-growth rate th ...

Assuming interest and dividends are paid annually calculate

Assuming interest and dividends are paid annually, calculate the annual holding period return on each security. Round answer to 1 decimal place. Stock 1: beginning of year price 44.00, end of year price 48.25, interest/d ...

Forecasting problem -double exponential smoothing using the

FORECASTING Problem - Double Exponential Smoothing: Using the Durable Marbles Inc. - a company with corporate head office in Europe, table data given below, compute the exponential smoothing with smoothing coefficients o ...

A bmw dealership is charging a financing rate of 350 apr on

A BMW dealership is charging a financing rate of 3.50% APR on its M3 car. The payments are to be made bi-weekly (i.e., every two weeks). Alternatively, you can get a loan from a bank to buy the car. The bank asks you to ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert