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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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