50.1K

Verified Solution

Link Copied!

Please Use Cell References In Excel!!

Beryl's Iced Tea currently rents a buttling machine for $50,000 per year, including all maintenance expenses. It is cunsidering purchasing a machine instead. and is comparing two options: .3. Purchase the machine it is currently ronting for $150,000. This machine will require $20,000 per year in ongoing maintenance expenses. b. Purchase a new, more advanced machine for $250,000. This machine will recuire $15, 0ba per year in oogoing mainte0ance expenses and will lower bottling costs by $10,000 per year. Also, $35,000 will be spent upfront in training the new operators of the machine. Suppose the appropriate discount rate is 8% per y ear and the machine is purchased today. Maintenance and botling costs are paid at the end af each y ear, as is the rental of the machine. Assume also that the machines will be depreciated via the straight-line methad over seven years and that they have a 10 -year life with a negligible salvage value. The marginal corporate tax rate is 21%. Should Beryl's leed Tea continue to rent, purchase its current machine, or purchase the advsnecd machine? Complete the meps bhelow using celi references to gtven data or prevous caiculations. in some canes, a simple celi reference is ail you need. To copyuste a directions widf speciff the use of that function. Do not type in numerical data into a celf or function. Instead, make a reference to the cell in which the data is forwulas, nsualjy de Given Dada

Answer & Explanation Solved by verified expert

See Answer