Question

In: Finance

Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK)...

Advanced Computers has decided to proceed with the manufacture and distribution of the virtual

keyboard (VK) the company has developed. To undertake this venture, the company needs to

obtain equipment for the production of the microphone for the key board. Because of the

required sensitivity of the microphone and its small size, the company needs specialized

equipment for production.

Lucas Johnson, the company president, has found a vendor for the equipment. Memtech

Acoustical Equipment has offered to sell Advanced Computers the necessary equipment at a

price of $4.3 million. Because of the rapid development of new technology, the equipment will

be fully depreciated after four years with the straight line depreciation approach. At the end of

the fourth year, the market value of the equipment is expected to be $450,000.

Alternatively, the company can lease the equipment. Two leasing companies, Hendrix Leasing

and International Leasing Corporation, offered their leasing terms to Advanced Computers.

Hendrix proposed the following lease contract: The lease contract calls for monthly payment of

$90,000 due at the beginning of each month for four years. Additionally, Advanced Computers

must make a security deposit $200,000 at the beginning of the lease contract (i.e. at the

beginning of the first month) and the deposit will be returned when the lease expires at the end of

the last month.

International Leasing Corporation proposed the following lease contract: The lease contract calls

for monthly payment of $91,500 due at the beginning of each month for four years without

security deposit.

Advanced Computers can borrow a loan with the interest rate of 10% per year from a bank to

finance the equipment. The company has a marginal tax rate of 21%.

Questions:

1. Use Excel to calculate the net present values (NPVs) (it is also called net advantage to

leasing (NAL)) for Advanced Computers based on the lease contracts proposed by

Hendrix Leasing and International Leasing Corporation, respectively.

I am re-posting this question because the previous answer I received did not have a clear explanation

Solutions

Expert Solution

NPV for advanced computers based on the lease contract proposed byhendrix leasing and international leasing corporation respectively is gieven below in screenshots from excel sheet attached here in.

Please note that i ii have attached 3 images of excel which are "with excel formulas" and 3 images from excel which are "without excel formulas"


Related Solutions

Case Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard...
Case Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK) the company has developed. To undertake this venture, the company needs to obtain equipment for the production of the microphone for the key board. Because of the required sensitivity of the microphone and its small size, the company needs specialized equipment for production. Lucas Johnson, the company president, has found a vendor for the equipment. Memtech Acoustical Equipment has offered to sell Advanced...
Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK)...
Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK) the company has developed. To undertake this venture, the company needs to obtain equipment for the production of the microphone for the key board. Because of the required sensitivity of the microphone and its small size, the company needs specialized equipment for production. Lucas Johnson, the company president, has found a vendor for the equipment. Memtech Acoustical Equipment has offered to sell Advanced Computers...
The Decision to Lease or Buy at Warf Computers Warf Computers has decided to proceed with...
The Decision to Lease or Buy at Warf Computers Warf Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK) the company has developed. To undertake this venture, the company needs to obtain equipment for the production of the microphone for the keyboard. Because of the required sensitivity of the microphone and its small size, the company needs specialized equipment for production. Nick Warf, the company president, has found a vendor for the equipment. Clapton...
A company has decided to replace its inspection machine with an advanced one. The advanced machine...
A company has decided to replace its inspection machine with an advanced one. The advanced machine costs $15,000. Use the information given in the following table and assume a MARR of 9% and the machine’s service life of 4 years to determine the economic life of the new machine j S.V. Operating Costs 1 $6,000 $3,600 2 $5,400 $5,600 3 $4,860 $7,600 4 $4,374 $9,600
As the Data Manager (DM) on the “TES-100” project, the CEO has decided to proceed with...
As the Data Manager (DM) on the “TES-100” project, the CEO has decided to proceed with the study and wants you to consider using the new savvy company system of remote data entry/electronic data capture. Review the current literature (i.e. internet) regarding this topic and decide if this study would be RDE/EDC appropriate, then write a 2-3 page paper or 20-25 slides on why you have made the decision you have made including pros and cons.
Before finalizing the design of a keyboard, an electronics company decided to conduct an experiment to...
Before finalizing the design of a keyboard, an electronics company decided to conduct an experiment to see the effect of two design choices (backlight: red vs. blue; product weight: heavy vs. light) on customers' attitude towards the product (measured on a scale of 1 to 7). Run the appropriate statistical test and at .05 level identify whether these design choices have an effect on consumers' attitude towards the product. Identify if there is a significant interaction effect (at .05 level)....
The certificate in Computers has a duration which approximates a normal distribution with a mean of...
The certificate in Computers has a duration which approximates a normal distribution with a mean of 266 months and a standard deviation of 16 months. What is the probability that the certificate last between 240 and 270 days? *
Computer Inc. is one of the pioneers in the manufacture of microprocessor for computers. On April...
Computer Inc. is one of the pioneers in the manufacture of microprocessor for computers. On April 1, 2018, Intel issued $1,600,000 of 12% face value bonds for $1,703,411.40. The bonds are due in 4 years, and pay interest semiannually on September 30 and March 31. Intel sold the bonds to yield 10%. Use the spreadsheet included in the module section to prepare a bond interest expense and premium amortization schedule using the straight-line method. Use the same spreadsheet to prepare...
A manufacture of laptop computers has four models, two with color lcd (liquid crystal display) screens...
A manufacture of laptop computers has four models, two with color lcd (liquid crystal display) screens (the spot model and the superba model) and two model with black and white lcd screens ( the standard model and the excel model). each model required assembly and test time and the requirements are shown in the table 2, together with the amount of time available for assembly and testing next month. LCD. the lcd screens are purchased from and outside supplier and,...
Doc Brown has decided to manufacture and sell Mr. Fusion home energy reactors. In the present,...
Doc Brown has decided to manufacture and sell Mr. Fusion home energy reactors. In the present, he is the only seller (but in the future, manufacturers are ubiquitous). Doc’s company faces the following demand curve: Q=80-2P He can produce Mr. Fusions at a constant marginal cost of 5 bitcoins. a) (5) How many Mr. Fusions will Doc sell and at what price? Circle your answers. b) (10) Suppose the government puts in a price ceiling at 6 bitcoins. What does...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT