# Finance:Cost of capital, Capital budgeting and Bonds.

Not what you're looking for?

I need step by step calculations using EXCEL functions showing how these 7 problems would be solved. The answers to each problem is at the end of the attachment.

Please use EXCEL functions/formulas to show how each problem can be solved and a brief explanation of what the answers mean. That will help me to greatly understand.

Thanks!

##### Purchase this Solution

##### Solution Summary

The problem set deals with determining share value, cost of equity, internal rate of return, net present value etc with provided information.

##### Solution Preview

9 - 13

Market price 39

Growth rate 4%

Dividend 1.5

Cost of retained earnings 7.85% =(1.5 + (4% * 39))/39

9 - 16

Risk-free rate 3%

Market return 11%

Beta 1.6

Cost of equity 15.8% =3% + (1.6 * (11% - 3%))

9 - 19

Weight Flotation cost Selling price Dividend Growth rate After-tax Cost

Debt 50% 6.60% 3.3%

Preferred stock 17% 0.75 26 2 13% 7.9% 1.3%

Common equity 33% 4.00 143 7 13% 18.0% 6.0%

Total 1.00 WACC 10.632%

10 - 11

a.

Cal Aron

Cash flows Cash flows

Year Outflow Inflow Outstanding balance Year Outflow Inflow Outstanding balance

0 -2,000 -2,000 0 -2,500 -2,500

1 900 -1,100 1 1,500 -1,000

2 1100 0 2 1,300 300

3 1300 1,300 3 800 1,100

Payback period 2 Years. Payback period 1 Year, 9 months

b.

Cash ...

###### Education

- B. Sc., University of Nigeria
- M. Sc., London South Bank University

###### Recent Feedback

- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"

##### Purchase this Solution

##### Free BrainMass Quizzes

##### SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

##### Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

##### Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

##### Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.