Find Jobs
Hire Freelancers

capital budgeting word and excel case

₹600-1500 INR

已完成
已发布超过 5 年前

₹600-1500 INR

货到付款
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.
项目 ID: 18127554

关于此项目

3提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
3威客以平均价₹1,133 INR来参与此工作竞价
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
JERSEY CITY, United States
0.0
0
会员自11月 9, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。