Final Homework

I have uploaded the assignment homework, it should be completed in a excel form and answer the short answer questions step by step.

By successfully completing this assignment , you will demonstrate your proficiency in the following course competencies and scoring guide criteria:

• Competency 1: Explain financial environments and concepts.
• Explain why forecasting and budgeting are essential practices for businesses, governmental agencies, and individuals.
• Explain the relationship between microeconomics and macroeconomics.
• Explain how the standard deviation of returns in a portfolio changes as the number of stocks within the portfolio increases.
• Explains which group of stocks makes up the more diversified portfolio.
• Competency 2: Apply financial computations and processes.
• Calculate the amount of a monthly mortgage payment.
• Calculate the approximate price at which a preferred stock will most likely sell.
• Calculate a bond’s value given a specific yield to maturity.
• Calculate the yield or return on a preferred stock.
• Calculate the total dollar return on an investment, including both capital gains and dividend income.
• Calculate the Net Present Value (NPV) of an investment, and whether one should proceed with the project.
• Competency 3: Communicate effectively and professionally.
• Convey clear meaning through appropriate word choice and usage.