Find Jobs
Hire Freelancers

capital budgeting word and excel case

₹600-1500 INR

Completed
Posted over 5 years ago

₹600-1500 INR

Paid on delivery
You need to help EIS decide whether to go ahead with the Pathrite system or not. Provide all relevant information and analysis,including a computation of the net present value and internal rate of return of the Pathrite system project. This case is about capital budgeting. However, some of the issues that you will need to grapple with are raised in the modules covering Stock Valuation and Capital Markets. Keep in mind that there is a lot of information in the case: regarding each piece of information, ask yourself whether it's relevant or not and if relevant, how. Keep in mind also that cost of capital is a conceptual quantity that can be measured using several pieces of information. Capital Budgeting is not a mechanistic exercise, not in the forecasting of cashflows and not in the estimation of cost of capital. Note that you should use the weighted average cost of capital formula to compute the cost of capital, viz. WACC = (proportion of equity in the firm's liability structure)(cost of equity capital) + (proportion of debt in the firm's liability structure)(cost of debt capital)(1-marginal tax rate). The write-up should be in Word (with an accompanying Excel spreadsheet showing the computations) You first need to come up with the basic incremental cashflows. That involves simply computing the after-tax earnings year-by-year and adding back depreciation. The treatment of inflation has to be consistent with the discount rate used. You can treat all the cashflows as nominal cashflows, incorporating inflation and then you don’t have to do anything about the inflation rate given. However, the constant assumed savings makes that unlikely. So if the savings are treated as savings, unadjusted for inflation, the right thing to do is to inflate the savings at the rate of inflation. However, it is important to keep in mind that tax savings do not increase at the rate of inflation. Also, the discount rate for nominal cashflows has to be a nominal rate, not an inflation-adjusted real rate. The depreciation used in my attached Excel spreadsheet follows the half-year life convention, which says that EIS could start depreciating in year zero, as long as the purchase had occurred in year zero (but I am not necessarily looking for this much sophistication). The key thing in the computation of the discount rate is the realization that there are many ways of computing the cost of equity and the cost of debt. For the cost of debt, the bond yield could be used or the yield on comparably rated bonds could be used. The 8% coupon rate is not the cost of debt unless the debt is sold at par, in which case it would be the yield, as well. For the cost of equity, you can use the CAPM, but that is only one method. You could also use the Gordon growth model formula, which says that r = D/P + g (this will be discussed in more detail in Module 9). You could also look at the actual historical average return. Finally, I expect you to think about sensitivity. Taking the expected cashflows is not recognizing the sensitivity of the realized NPV to the actual cashflows. Looking at the NPV separately under the different scenarios allows us to look at the probability of ending up with a negative realized NPV, which you don’t get by simply using the expected cashflows in your computation. please refer the below screenshots of the pdf from Excelerite Integrated Systems, Inc. (EIS) and upload a screenshot of the word file ans excel sheet workings.
Project ID: 18127554

About the project

3 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am Chartered Accountant with 15 years of experience, in financial analysis, book keeping, accounting, budgeting I can complete this job to the best of your expectations Thanks
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
3 freelancers are bidding on average ₹1,133 INR for this job
User Avatar
Hi there! With respect,How are you doing? I hope you are fine. I have checked the project details and I can do this perfectly. I have huge experience in working with these projects. So no worries about it. I will provide you the best quality work. I'm waiting for your kind resonse.
₹800 INR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
JERSEY CITY, United States
0.0
0
Member since Nov 9, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.