Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please do it in your computer and take picture for this answer in EXCEL please Tax Problem Answer the following questions using Excel. Partial credit

image text in transcribedPlease do it in your computer and take picture for this answer in EXCEL please
Tax Problem Answer the following questions using Excel. Partial credit will be given only if the work is done in a neat and orderly fashion. Box in your final answer. A road construction firm was just awarded a S21 million contract. As part of their contract they will need to purchase 2-143H Qaterpillar graders. The cost of the graders is scrapers. each. These graders will be used to maintain the haul roads used b 14 loads of By having the graders maintain the haul road the company realizes 14 more dirt moved by the scrapers per hour (each scraper gets load per hour). The company makes $10 profit per load of dirt. The company projects this savings to occur over 5 years and each year the company will work for 60 days and the crew works 10 hours per day. The company qualifies for a 5% income tax credit on the purchase of the scrapers. The company is in the 39% tax bracket and uses MACRS depreciation for the scrapers with a class life of 3 years. At the end of five years the company will sell the graders for $50,000 each. The company will realize a 34% tax rate on capital gains/losses. Answer the following questions: 1. What is the Before Tax Rate ofReturn (compute to nearest 1/10 of a percent) 2. What is the After Tax Rate of Return? (compute to the nearest 1/10 of a percent) 3. If your MARR is 6% is this a good investment? 4. After further research it is determined that you will realize 21 more loads of dirt 4. After further research it is determined that you will realize 21 more loads of dirt moved per hour. With your MARR of 6% should you invest in the graders? point problem) Rate of Return Problem Consider three mutually exclusive alternatives for an investment. Initial Cost 100,000 S130,000 is200,000 Ls330,000 Uniform Annual Benefit S31,520 Uniform Annual Costs 8% of First Cost Salvage 10% of first cost Use a Rate of Return Analysis and Excel to solve for the following: Which alternative should be chosen using an MARR of 6%? Using a Mathematical Rate of Return Solution (5 points) Using a graphical solution to the problem indicating which altemative should be chosen for interest rates from 0-20%. (5 points). Make sure your graph has all proper labels. Create a choice table from 0-20%. (5 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of European Fixed Income Securities

Authors: Frank J. Fabozzi, Moorad Choudhry

1st Edition

0471430390, 978-0471430391

More Books

Students also viewed these Finance questions