Use spreadsheet to perform feasibility analysis

Assignment Help Financial Accounting
Reference no: EM131292710

Rossco is considering the purchase of a new computer with the following estimated costs: initial systems design, $54,000; hardware, $74,000; software, $35,000; one time initial training, $11,000; system installation, $20,000; and file conversion, $12,000. A net reduction of three employees is expected, with average yearly salaries of $40,000. The system will decrease average yearly inventory by $150,000. Annual operating costs will be $30,000 per year.

The expected life of the machine is four years, with an estimated salvage value of zero. The effective tax rate is 40%. All computer purchase costs will be depreciated using the straight line method over its four year life. Rossco can invest money made available from the reduction in inventory at its cost of capital of 11%. All cash flows, except for the initial investment and start-up costs, are at the end of the year. Assume 365 days in a year.

REQUIRED

Use a spreadsheet to perform a feasibility analysis to determine whether Rossco should purchase the computer. Compute the following as part of the analysis: intial investment, after-tax cash flows for years 1 through 4, payback period, net present value, and internal rate of return.

Reference no: EM131292710

Questions Cloud

Statement of cash flows under fifo-lifo and weighted average : The accounting records of Freds Sporting Goods reflected the following balances as of January 1 2015. Compute the cost of goods sold and ending inventory, assuming FIFO cost flow. Prepare the 2015 income statement (mulit-step), balance sheet and stat..
Estimate the ph of cloud water : The concentration of sulfate in the atmosphere over oceans is -0.06μg/m3. If the water content of cloud is 1 g/m3, estimate the pH of cloud water. Assume that all the sulfate exists as sulfuric acid.
Examples of satisfactory responsiveness : Describe large, bureaucratic organizations with which, you have had contact that have not responded flexibly to customer demands. Also describe examples of satisfactory responsiveness. What do you think accounts for the differences between the res..
Defines prohibited activities of public employees : According to the text, the Hatch Act defines prohibited activities of public employees. Analyze the significance of these prohibitions with regard to an individual's political actions. Provide a rationale for your response.
Use spreadsheet to perform feasibility analysis : Rossco is considering the purchase of a new computer with the following estimated costs: initial systems design, $54,000; hardware, $74,000; software, $35,000; one time initial training, $11,000; system installation, $20,000; and file conversion, $12..
Why are writing skills especially essential : Why is it important for business and professional students to develop good communication skills, and why are writing skills especially essential?
Estimate the mean aqueous concentration of benzene : Estimate the mean aqueous concentration of benzene allowed in the impoundment. The area of the impoundment is 104 m2.
How are listening skills important to employees : How are listening skills important to employees, supervisors, and executives? Who should have the best listening skills?
The partnerships capital balances : Gibbs, Cook, and Chan are partners and share income and loss in a 5:1:4 ratio. The partnership's capital balances are as follows: Gibbs, $606,000; Cook, $148,000; and Chan, $446,000. Prepare journal entries to record Gibbs's April 30 withdrawal from ..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Adjusted unamortized bond premium is what amount

On January 1, 2010, Solis Co. issued its 10% bonds in the face amount of $3,000,000, which mature on January 1, 2020. The bonds were issued for $3,405,000 to yield 8%, resulting in bond premium of $405,000. Solis uses the effective-interest method of..

  With five production facilities

Juniper Packaging Solutions, Inc., provides custom packaging products to companies all over the United States. With five production facilities, the company produces cardboard boxes, plastic and steel drums, aluminum bottles, and absorbent pouches and..

  Pro forma income statementassuming that reeds can improve

pro forma income statement.assuming that reeds can improve its operations to be in line with the industry averages

  Summary operating data for eco windows company

Summary operating data for eco windows company during the current year ended june 30,20 y6,are as follows: cost of merchandise sold,$3,800,00;administrative expenses $1,200,000;interest expense ,$100,000;rent revenue,$200,000;net sales,$9,300,000;and..

  Preparation of the single-step and multiple-step income

preparation of the single-step and multiple-step income statementthe following data were taken from the records of

  The stockholders'' equity section of the balance sheet

The stockholders' equity section of the balance sheet for Pental, Inc., follows before the stock dividend. Common stock, $1 par, 100,000 shares issued and outstanding $100,000 Additional paid-in capital 50,000 Retained earnings 450,000 Total stockhol..

  Critical perspective of accounting

What is the article or the research about - What topic, theory or concepts in Accounting Theory does the article relate to?

  Schedule of interest bond and revenue discount amortization

Prepare a 3-year schedule of interest bond and revenue discount amortization, applying the straight-line method ?

  Periodic inventory system

ABC Company employs a periodic inventory system and sells its inventory to customers for $32 per unit. ABC Company had the following inventory information available for the month of May: Calculate the dollar amount of ending inventory shown on ABC Co..

  Prepare a depreciation schedule showing net book value

Prepare a depreciation schedule: Z Company’s fiscal year starts July 1st and ends June 30th. The company purchased a new machine which was installed and operational at the beginning of the second quarter in October. Prepare a depreciation schedule sh..

  What is charitable contribution deduction

In 2015, Webtel Corporation donated $50,000 to a qualifying charity. For the year, it reported taxable income of $310,000, which included the following: the $50,000 charitable contribution (before limitation), a $100,000 dividends received deduction,..

  Insurance policy for coverage beginning on that date

1.On March 1, 2011, a company paid a $18,000 premium on a 36 month insurance policy for coverage beginning on that date. Refer to that policy and fill in the blanks in the followingt able.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd