Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer using excel please Initial cash flow: Basic calculation Cushing Corporation is considering the purchase of a new grading machine to replace the existing one.

image text in transcribedAnswer using excel please

Initial cash flow: Basic calculation Cushing Corporation is considering the purchase of a new grading machine to replace the existing one. The existing machine was purchased 2 years ago at an installed cost of $21,000; it was being depreciated under MACRS using a 5-year recovery period. (See table for the applicable depreciation percentages.) The existing machine is expected to have a usable life of at least 5 more years. The new machine costs $35,900 and requires $5,000 in installation costs; it will be depreciated using a 5-year recovery period under MACRS. The existing machine can currently be sold for $24,600 without incurring any removal or cleanup costs. The firm is subject to a 21% tax rate. Calculate the initial cash flow associated with the proposed purchase of a new grading machine. The initial cash flow will be $ (Round to the nearest dollar.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year* Recovery year 3 years 5 years 7 years 10 years 1 33% 20% 14% 10% 2 45% 32% 25% 18% 3 15% 19% 18% 14% 4 7% 12% 12% 12% 5 12% 9% 9% 6 5% 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 4% Totals 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%) depreciation using the half-year convention

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

Ecological Money And Finance

Authors: Thomas Lagoarde-Segot

1st Edition

3031142314, 978-3031142314

More Books

Students also viewed these Finance questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago