[CUSTOM SOLUTION] A Financial Manager

The WACC spreadsheet provides a tool for understanding the calculation of WACC and the affect in changes of the components of WACC. The spreadsheet automates the WACC calculation so the emphasis on this assignment is on understanding the implications the various inputs to the WACC calculation. Clicking the various buttons on the Financial Statements worksheet and the Calculate WACC worksheet calculate the WACC for the company. Since some information carries over between worksheets you should start with the Financial Statements worksheet. The Scenarios worksheet has spinner buttons that automate the process of changing various factors. The Scenarios sheet allows you to vary those factors and then recalculate WACC. Since working with somebody else’s spreadsheet takes some getting used to, I suggest that you try to use this spreadsheet and then contact me via email or office hours with any questions.Assume you are a financial manager in the company. The CFO believes that understanding its WACC is critical for the company to make good financial decisions. The CFO believes that if the company’s WACC increases above 10% it will create very real hardship. The CFO has asked you to calculate the companies WACC and what effects it. You should use the spreadsheet provided.Since WACC can be calculated with either the SML or the dividend growth model, please use both WACC SML and WACC DIVIDEND GROWTH. The spreadsheet calculates WACC and allows you to perform sensitivity analysis on the key factors affecting WACC.The following factors affect WACC:1. The cost of debt (rD)2. The corporate tax rate (TC)3. The risk free rate (rRF)4. The market risk (?)5. The market rate of return (rM)6. Current Stock Price (P)7. Dividend Growth Rate (g)8. The current dividendUsing the “Sensitivity” worksheet to adjust the above factors and comment the impact.Which two factors do you think have the largest effect on WACC SML? WACC DIVIDEND GROWTH?Extra credit: Assess and comment on the company’s leverage and how any changes there might affect WACC.Please note the following:1. In somewhat of a departure from the lecture, the WACC Spreadsheet uses interest expense/debt outstanding to determine cost of debt. This is an acceptable way to determine cost of debt ifa) information regarding market value of debt is not available. Book value of debt is not perfect, but it is the best available in this case. The spreadsheet uses the market value of the equity.b) reported interest expense is not net of significant interest income.2. Tax rate (TC) is calculated using 2018 Earnings Before Taxes and Income Tax Expense. This is correct if there was nothing unusual regarding taxes in 2018. This determines what the effective tax rate was as opposed to the statutory tax rate. Often the effective tax rate is a more realistic representation of the actual taxes paid by a company.

 

Don't use plagiarized sources. Get Your Custom Essay on
[CUSTOM SOLUTION] A Financial Manager
Get a 15% discount on this Paper
Order Essay

 

Assignment posted by client #4327***

Quality Guaranteed

With us, you are either satisfied 100% or you get your money back-No monkey business

Check Prices
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know that being a student these days is hard. Because of this, our prices are some of the lowest on the market.

Instead, we offer perks, discounts, and free services to enhance your experience.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with My Paper Support
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Other
GOOD
Customer 452813, July 5th, 2022
Strategic Management
Thanks for the help, really appreciate it
Customer 452821, September 8th, 2022
Other
AWESOME
Customer 452813, June 25th, 2022
Education
Thank you so much for all the help, I really appreciate it!
Customer 452631, November 3rd, 2021
Business and administrative studies
GREAT
Customer 452813, June 30th, 2022
Medicine
Great job! Thank you.
Customer 452707, May 29th, 2022
Nursing
Amazing work! I passed the assignment!
Customer 452707, August 20th, 2022
Criminal Justice
Excellent Work!!!
Customer 452587, March 10th, 2022
Psychology
Thank you so very much!!!
Customer 452517, May 11th, 2021
Other
GREAT JOB THANK YOU.
Customer 452813, July 18th, 2022
Criminal Justice
always great!
Customer 452465, February 23rd, 2021
Nursing
Great work! Thank you so much.
Customer 452707, July 15th, 2022
Enjoy affordable prices and lifetime discounts
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Order Now Order in Chat

SAVE BIG FOR FINALS. Order your essay today and save 20% with the discount code SPECIAL20