This two-part project will focus on the financial aspects of your start up business. This project also includes the use of Excel spreadsheets containing financial data and required reports.

Before you begin, take this tutorial on financial statements.

In part I, using Microsoft Excel worksheets create 3 years of income statements, balance sheets, and cash flow statements.

In part 2, using Microsoft Word®, create a 3–4 page financial summary detailing your income statements, balance sheets, and cash flow statements.

When you are ready, submit your Microsoft Word Document and Excel file on the Dropbox page. *Note, include your name in the file name of each Assignment.

Assignment checklist Items:

Create an income statement and balance sheet.

Create cash flow analysis.

Create an Excel spreadsheet that includes the financial aspects associated with your Final Project, including income statements, balance sheets, and cash flow statements.

Complete a financial summary on Excel Spreadsheet financial reports.

For help using the Dropbox, click on Academic Tools above then Dropbox Guide.

Aspect	Percentage of assignment	Score	MT499 Assignment Criteria
Content, Focus, use of Research	50% (30pts)		Addresses all assignment requirements, indicates depth of knowledge about the topics and key areas, contains a clear and concise introduction with a thesis statement, comprehension body of paper, closing summary, and includes a minimum of three cited and referenced resources (APA 6th edition).
Analysis and Critical Thinking	30% (18pts)		Analysis and critical thinking indicates optimal reasoning with a defined purpose, based on assumptions, writer’s point of view, discusses the advantages and disadvantages, and uses data, information, and concepts/ideas to address the assignment topics or key areas in the paper.
Writing Style, Grammar, APA Format	20% (12pts)		The capstone uses the APA (6th edition) writing style using active voice, which is in third person and concisely written. The paper is free from incorrect punctuation, use of jargon/clichés, incorrect grammar and mechanics, and is correctly formatted based on APA 6th edition guidelines.
Total Points	100% (60pts)

ID: MT499-08-07-A

((Word document of 700–1,000 words with attached Excel Spreadsheet showing calculations)) 

After engaging in a dialogue with your colleagues on valuation, you will now be given an opportunity to apply principles that were presented in this phase. Using a Web site that provides current stock and bond pricing and yield information, complete and analyze the tables illustrated below. Your mentor suggests using a Web site similar to this one.

To fill out the first table, you will need to select 3 bonds with maturities between 10 and 20 years with bond ratings of “A to AAA,” “B to BBB” and “C to CC” (you may want to use bond screener at the Web site linked above). All of these bonds will have these values (future values) of $1,000. You will need to use a coupon rate of the bond times the face value to calculate the annual coupon payment. You should subtract the maturity date from the current year to determine the time to maturity. The Web site should provide you with the yield to maturity and the current quote for the bond. (Be sure to multiply the bond quote by 10 to get the current market value.) You will then need to indicate whether the bond is currently trading at a discount, premium, or par.

Bond	Company/ Rating	Face Value (FV)	Coupon Rate	Annual Payment (PMT)	Time-to Maturity (NPER)	Yield-to-Maturity (RATE)	Market Value (Quote)	Discount, Premium, Par
A-Rated	$1,000
B-Rated	$1,000
C-Rated	$1,000

• Explain the relationship observed between ratings and yield to maturity.
• Explain why the coupon rate and the yield to maturity determine why the bonds would trade at a discount, premium, or par.
• Based on the material you learn in this Phase, what would you expect to happen to the yield to maturity and market value of the bonds if the time to maturity was increased or decreased by 5 years?

In this step, you have been asked to visit a credible Web site that provides detailed information on publicly traded stocks and select 1 that has at least a 5-year history of paying dividends and 2 of its closest competitors.

To fill up the first table, you will need to gather information needed to calculate the required rate of return for each of the 3 stocks. You will need to calculate the risk-free rate for this assignment. You will need the market return that was calculated in Phase 2, and the beta that you should be able to find on the Web site.

Company	5-year Risk-Free Rate of Return	Beta (β)	5-Year Return on Top 500 Stocks	Required Rate of Return (CAPM)

To complete the next table, you will need the most recent dividends paid over the past year for each stock, expected growth rate for the stocks, and the required rate of return you calculated in the previous table. You will also need to compare your results with the current value of each stock and determine whether the model suggests that they are over- or underpriced.

Company	Current Dividend	Projected Growth Rate (next year)	Required Rate of Return (CAPM)	Estimated Stock Price (Gordon Model)	Current Stock Price	Over/Under Priced

In the third table, you will be using the price to earnings ratio (P/E) along with the average expected earnings per share provided by the Web site. You will also need to compare your results with the current value of each stock to determine whether or not the model suggests that the stocks are over- or underpriced.

Company	Estimated Earning (next year)	P/E Ratio	Estimated Stock Price (P/E)	Current Stock Price	Over/Under Priced

After completing the 3 tables, explain your findings and why your calculations coincide with the principles related to bonds that were presented in the Phase. Be sure to address the following:

• Explain the relationship observed between the required rate of return, growth rate and the dividend paid, and the estimated value of the stock using the Gordon Model.
• Explain the value and weaknesses of the Gordon model.
• Explain the how the price-to-earnings model is used to estimate the value of the stocks.
• Explain which of the 2 models seemed to be the most accurate in estimating the value of the stocks.
• Based on the material that you learn in this Phase, what would you expect to happen to the value of the stock if the growth rate, dividends, required rate of return, or the estimated earnings per share were to increase or decrease? Be sure to explain each case separately.

Note: You can find information about the top 500 stocks at this Web site.

 

Please see attached 2 files for 1st Project:

* Project’s outline/requirements from the professor

* Old projects from 2013 – 99% turn-it-in. This file will be used as the “base” for my project. It has old data from 2013 – s/b all replaced by new data (from 2016 is possible and/or available).

I attached old project so you can see how it was done in the past and also my project is on AT&T too. Please make sure to use current info and calculations.

Assignment 1: Small-Business Opportunities with the Navy

Due Week 3 and worth 150 points

Imagine that you are the owner of a small floor refinishing business that provides a specialty coating product for ceramic tile and marble floors. There is no other local flooring business that provides this service. Having recently received a patent on your product, you are ready to expand your business by competing for Navy contracts at the local base, which is located a few miles away. The service you want to sell is the specialty coating, the application of the coating, and a regular maintenance schedule. Your company consists of you, one office assistant, and two production employees. 

Note: You will be referencing this business throughout all five assignments for this course. Please use “First Name, Last Name, Inc.” as the name of your company throughout these assignments.

Write a two to three (2-3) page paper in which you:

1. Develop your company’s acquisition and planning strategy for obtaining a contract. 
2. Analyze the manner in which utilizing SmartPay or a similar program in electronic contracting will assist your company and the Navy. Provide a rationale for your response.
3. Use at least three (3) quality references Note: Wikipedia and other related websites do not qualify as academic resources. 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

• Describe the nature of government contracting, including authority, responsibilities, and legal considerations.
• Explain the government acquisition process using sealed bidding, negotiations, and alternative contracting methods.
• Use technology and information resources to research issues in federal acquisition and contract management.
• Write clearly and concisely about federal acquisition and contract management using proper writing mechanics.

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills. Click here to access the rubric for this assignment.

What does the NLRA say about an employee’s participation with social media?  Does the law give complete freedom to employees and protect them from employment consequences? (2 paragraph)

http://hiring.monster.com/hr/hr-best-practices/small-business/news/nlrb.aspx

https://www.nlrb.gov/news-outreach/fact-sheets/nlrb-and-social-media