Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the two problems below (P1 and P2). Fivemarks each. Part marks will be allocated. Project 1 Calculations must be done in Excel The financial

Answer the two problems below (P1 and P2). Fivemarks each. Part marks will be allocated.

Project 1Calculations must be done in Excel

The financial advisor to PQR Company is evaluating whether to keep company cars for 3, 4, 5 or 6 years. The following information has been gathered:-

A car costs $80,000 and depreciation is 25% pa straight-line.

Cash expenses are $20,000 per year for the first 2 years, $30,000 in year 3, $40,000 in year 4, $50,000 in year 5 and $60,000 in year 6.

The salvage value is expected to be $30,000 after 3 years, $25,000 after 4 years, $20,000 after 5 years and $10,000 after 6 years.

The after tax required rate of return is 10% pa and the tax rate is 30%.

Required

Prepare an analysis to decide whether company cars should be kept for 3, 4, 5 or 6 years before being replaced with new ones.

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

Public Finance and Public Policy

Authors: Jonathan Gruber

5th edition

1464143331, 978-1464143335

More Books

Students also viewed these Finance questions

Question

=+b) Compute the SD for each decision.

Answered: 1 week ago