Construct a table showing your calculations of net cash flow

Assignment Help Financial Accounting
Reference no: EM131182157

Project 1

Polycorp is considering an investment in new plant of $3.1 million. The project will be financed with a loan of $2,000,000 which will be repaid over the next five years in equal annual end of year instalments at a rate of 6.5 percent pa. Assume straight-line depreciation over a five-year life, and no taxes. The projects cash flows before loan repayments and interest are shown in the table below. Cost of capital is 12.15% pa (the required rate of return on the project). A salvage value of $255,000 is expected at the end of year five and is included in the cash flows for year five below. Ignore taxes and inflation.

Year

Year One

Year Two

Year Three

Year Four

Year Five

Cash Inflow

880,000

860,000

810,000

910,000

945,000

You are required to calculate:

(1) The amount of the annual loan repayment and produce a repayment schedule.
(2) NPV of the project (to the nearest dollar)
(3) IRR of the project (as a percentage to two decimal places)
(4) AE, the annual equivalent for the project(AE or EAV) (to the nearest dollar)
(5) PB, the payback and discounted payback in years (to one decimal place)
(6) ARR, the accounting rate of return (gross and net) (to two decimal places)
(7) PI (present value index or profitability index) (to two decimal places)
(8) Is the project acceptable? You must provide a decision or explanation for each of the methods in parts (2) to (7).Why or why not (provide a full explanation)? Also a brief explanation of your treatment of Salvage Value and Loan Repayments is required.

Project 2

Polycorp Limited Steel Division is considering a proposal to purchase a new machine to manufacture a new product for a potential three year contract. The new machine will cost $1.5 million. The machine has an estimated life of three years for accounting and taxation purposes. The contract will not continue beyond three years and the equipment's estimated salvage value at the end of three years is $128,000. The tax rate is 29 percent and is payable in the year in which profit is earned. An investment allowance of twenty five percent on the outlay is available. The after tax cost of capital is 12.85%pa. Addition net working capital of $72,000 is required immediately for current assets to support the project. Assume that this amount is recovered in full at the end of the three year life of the project. The new product will be charged $59,500 of allocated head office administration costs each year even though head office will not actually incur any extra costs to manage the project. This is in accordance with the firm's policy of allocating all corporate overhead costs to divisions. Extra marketing and administration cash outflows of $68,500 per year will be incurred by the Steel Division for the project. An amount of $159,000 has been spent on a pilot study and market research for the new product. The projections provided here are based on this work. Projected sales for the new product are 32,000 units at $133 per unit per year. Cash operating expenses are estimated to be 75 percent of sales (excludes marketing and administration, and head office items). Except for initial outlays, assume cash flows occur at the end of each year (unless otherwise stated).Assume diminishing value depreciation for tax purposes.

Required

(a) Construct a table showing your calculations of net cash flow after tax (NCFAT). Use the method shown in lectures and notes.
(b) Calculate the NPV. Is the project acceptable? Why or why not?
(c) Conduct a sensitivity analysis showing how sensitive the project is to operating expenses. Explain.
(d) Write a short report explaining your calculation of relevant net cash flows after tax, justifying your selection of cash flows. Be sure to state clearly any assumptions made (implicit and explicit).

Reference no: EM131182157

Questions Cloud

Expected number of people that leave the drive-thru : What is the expected number of people that leave the drive-thru with their orders filled in any given 4 minute interval?
How can you use goal-setting to increase motivation : Develop strategies to advance your career using your strengths. How can you use goal-setting to increase motivation and improve job performance? How might your engagement as an employee and job satisfaction influence job performance
How many ties of each type may it possibly have : Ties Unlimited stocks $1 ties, $2 ties, and $4 ties. If it has a total inventory of 7,000 ties valued at $12,000. How many ties of each type may it possibly have? If the number of $2 ties is 2,000 how many of each type are there?
Required to manufacture units : It took a contractor 1285 hours to manufacture their first unit of an item. If the contractor expects to achieve a 92% unit learning curve, how many hours would be required to manufacture units 52-100?
Construct a table showing your calculations of net cash flow : Construct a table showing your calculations of net cash flow after tax (NCFAT). Use the method shown in lectures and notes. Calculate the NPV. Is the project acceptable? Why or why not?
How might rubrics be used in performance assessments : How might rubrics be used in performance assessments? Imagine you are a new employee in a human resource (HR) department. Your first task is to develop a stress management seminar for the employees. Determine the topics that should be covered in th..
Create a script named test-files and : Create e script named all_users, which would  display a message and Create a script named test-files
Difference in the proportion of men and women : Suppose this survey was conducted using 374 men and 481 women. Do these data show enough evidence to support the conclusion that there is no difference in the proportion of men and women who think weight is a factor in purchasing a laptop? Use a 5..
Graph the company selected financial data : Graph the company's selected financial data. Explain the role of standard deviation in financial analysis. Explain any other uses for standard deviation in a business setting

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