Loading
Home › Finance Help › fin excel
Status: Completed
 View Work

fin excel

Date Posted: 24/04/2020
Category: Finance
Due Date: 24/04/2020
Instruction
This assignment is a capital budgeting case with an extra twist in which you also need to figure out the firm's cost of capital. This involves a step-by-step process in which you will calculate the cost of debt, the cost of equity, and the weights of debt and equity. (Note that the firm uses short-term debt in the form of a revolving line of credit, which has a particular interest rate, as well as long-term debt, which has a different yield.) Please show your work in an excel spreadsheet that uses cell references and formulas. In calculating the cost of equity, you can use CAPM. You will need to find beta, which can be done by regressing the returns for the company on the market returns over the same period. That is, the company's returns would be the dependent variable, and the market returns will be the independent variable. The slope of this regression is the beta for the company, similar to slides 19 & 20 in the Risk_Return slides. You can find the beta using a shortcut in excel, with the SLOPE function. You can look up the slope function (=slope) in excel for the exact inputs (which are the company returns and the market returns, which are given in the case). The slope calculated in excel will be the beta to be used in CAPM to find the cost of equity. Here is the case: File 1. Just need question 1-3
Attached
Download File 1 (pdf)
Tutor Uploads
Download File 1 (xlsx)
Bidders
Euphrates 6 years, 5 months ago
Rated 9.44 earned 62853.11 around 1902 assignments.
Hello dear friend, I'm online NOW and I'm happy to help you. I would like to express my interest in doing your assignment. I will go through your summary and instruction carefully and do your task. I promise to commit my skills and the great experience to guarantee you a top-notch quality paper, with zero grammatical errors, and a 100% free from PLAGIARISM. Besides my skill and experience, I respond promptly to my client and provide a quick turnaround. Kindly hire me, and I’ll make you proud. I’m looking forward to working with you. Thank you!
$25.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
phoniextutor 6 years, 5 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello my friend kindly ASSIGN ME
$25.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
tutor4U_d_971 6 years, 5 months ago
Rated 9.33 earned 53632.21 around 1383 assignments.
Get professional and exceptional academic services in SPSS, R, Excel, R-Markdown, StatCrunch, PhStat, Tableau, MATLAB, and Ms Project, Sociology, Religion, Political science, Psychology, Health Care, Nursing, Finance and Accounting, Economics, Business, Biology, HRM history and Government, Law, Auditing, Research papers, peer review articles, PPT slides, Calculus, Algebra online classes, and term papers. I guarantee distinct and excellent work. Quality, Timely and 100% plagiarism free work. Nothing short of A+++ and GPA 4.0
$50.00
  • how long it will take? I only need question(step) 1-3
    User_19638 | Apr 24, 2020, 03:37 AM
  • will be done within 12hrs
    tutor4U_d_971 | Apr 24, 2020, 03:38 AM
  • would that be okay with you?
    tutor4U_d_971 | Apr 24, 2020, 03:38 AM
  • yes, make sure upload it with excel
    User_19638 | Apr 24, 2020, 03:40 AM
  • I will
    tutor4U_d_971 | Apr 24, 2020, 03:58 AM
  • is ready yet?
    User_19638 | Apr 24, 2020, 17:51 PM
  • uploaded.
    tutor4U_d_971 | Apr 24, 2020, 18:31 PM
  • hello
    tutor4U_d_971 | Apr 27, 2020, 14:51 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
SolutionASAP 6 years, 5 months ago
Rated 8.96 earned 13184.04 around 380 assignments.
Hello Student, the topic and area of your assignment are quite familiar to me. I have handled several tasks on this area and delivered excellent results that rewarded my client’s high-quality grades. I can assure you that your paper will be keenly handled with exemplary expertise. I guarantee 100% unique and original content with 0% plagiarism. I will submit before the deadline. Feel free to engage me. Thank you.
$45.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
bestwitter 6 years, 5 months ago
Rated 9.88 earned 11890.84 around 425 assignments.
Hi, this is related to my field. kindly contact me for A++, 100% ORIGINAL PAPERS AT AFFORDABLE PRICES accompanied by free Turnitin report.
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
responsibleturtor 6 years, 5 months ago
Rated 9.53 earned 79912.53 around 2530 assignments.
Five reasons why you should let me write your paper. 1. 100% original 2. In line with your instructions 3. Perfectly referenced 4. Delivered on time 5. Plagiarism report provided
$40.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
kingz 6 years, 5 months ago
Rated 9.4 earned 52183.12 around 1434 assignments.
Hi, I will do it and make it an A+
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}