0 Comments

FIN 320 Project Two Guidelines and Rubric

Competencies

In this project, you will demonstrate your mastery of the following competencies:

  • Analyze financial and investment decisions that add value to the organization
  • Analyze financing options to maximize investor value

Scenario

You chose a business (Tesla Inc.) for your Module Two Journal. Imagine you are an analyst for that business. The business’s board of directors wants updates on the business’s financial health. Your supervisor has asked you to write a report that includes the following:

  • The business’s current financial health
  • The available financial options for improving the business
  • Your recommendations about which options will support the business’s financial health

Your supervisor will present your report to the business’s board of directors. The board members have different levels of knowledge about finance. You must write the report so it is easy for all board members to understand.

Directions

Create a report for your supervisor to share with the board of directors during their presentation. Use the business you chose from the Project Two Business Options List. Use Mergent Online to find the most recent quarterly financial statements for your company. Use these statements to support your analysis during the project. Use the Project Two Financial Assumptions document for descriptions of the three financial options you will evaluate. Use the Project Two Financial Analysis Report template to complete this project.

Note: All documents and resources that are needed to complete this assignment are linked in the What to Submit and Supporting Materials sections.

Specifically, you must address the following rubric criteria:

  1. Financial Analysis: For this section, you will start with calculating the financial formulas listed in Part A. Use the most recent quarterly financial statements from your chosen business and the Project Two Financial Formulas worksheet.
    1. Financial Calculations: Accurately calculate financial formulas to figure out the business’s current financial health. You must calculate the following:
      1. Working capital
      2. Current ratio
      3. Debt ratio
      4. Earnings per share
      5. Price/earnings ratio
      6. Total asset turnover ratio
      7. Financial leverage
      8. Net profit margin
      9. Return on assets
      10. Return on equity
    2. Working Capital Management: Explain the impact of working capital management on the business’s operations. Provide examples to support your claims.
    3. Financing: Explain how a business finances its operations and expansion.
    4. Short-Term Financing: Explain how potential short-term financing sources could help the business raise funds for improving its financial health. Base your response on the business’s current financial information.
    5. Bond Investment: Discuss the risks and benefits of the business investing in a corporate bond. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Project Two Financial Assumptions document and the Bonds section of the Net Present Value (NPV) worksheet in the Project Two Financial Formulas workbook.
    6. Capital Equipment: Discuss the risks and benefits of the business investing in capital equipment. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Project Two Financial Assumptions document and the Equipment section of the Net Present Value (NPV) worksheet in the Project Two Financial Formulas workbook.
    7. Building: Discuss the risks and benefits of the business investing in a building. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Project Two Financial Assumptions document and the Building section of the NPV worksheet in the Project Two Financial Formulas workbook.
  2. Financial Evaluation: In this section of the report, you will determine which of the three available investments are good financing options and describe the business’s likely future financial performance.
    1. Bond Investment: Determine if the bond investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to support your claims.
    2. Capital Equipment: Determine if the capital equipment investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to support your claims.
    3. Building: Determine if the building investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to support your claims.
    4. Future Financial Considerations: Describe the business’s likely future financial performance. Base your description on the business’s current financial well-being and risk levels. Use financial information to support your claims.

What to Submit

To complete this project, you must submit the following:

Financial Analysis Report
Submit your completed Project Two Financial Analysis Report.

You must also submit the Excel files for your chosen business’s balance sheet, income statement, and cash flow statement from Mergent Online.

Workbook: Project Two Financial Formulas
Use this Excel workbook to complete your calculations for the project. You should have already completed the Ratios worksheets for your Project Two Milestone assignment.

All sources should be cited according to APA style. This includes sources listed in your Project Two Financial Formulas workbook. Consult the Shapiro Library APA Style Guide for more information on citations.

RATIOS Most Recent Fiscal Qtr

ACCOUNTING & FINANCIAL RATIOS
CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets)
Current Assets $45,026,000 Total Revenue $23,350,000
Current Liabilities $26,640,000 1.6901651652 Total Assets $84,183,500 0.2773702685
WORKING CAPITAL (Current Assets – Current Liabilities) FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity)
Current Assets $45,026,000 Total Assets $93,941,000
Current Liabilities $26,640,000 18386000 Shareholder's Equity $53,466,000 1.7570231549
DEBT RATIO (Total Liabilities / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue)
Total Liabilities N/A Net Income $1,878,000
Total Assets $93,941,000 ERROR:#VALUE! Total Revenue $23,350,000 0.0804282655
EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets)
Net Income $1,851,000 Net Income $1,878,000
Shares Outstanding $3,493,000 0.5299169768 Total Assets $84,183,500 0.0223084096
PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) RETURN ON EQUITY (Net Income – Preferred Dividends / Shareholder's Equity)
Stock Price $250.22 NI – Pref. Div. $1,851,000
EPS $0.53 472.1132075472 Shareholder's Equity $53,466,000 0.0346201324

RATIOS Same Fiscal Qtr 1 Yr Ago

ACCOUNTING & FINANCIAL RATIOS
CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets)
Current Assets $35,990,000 Total Revenue $21,454,000
Current Liabilities $24,611,000 1.4623542318 Total Assets $65,021,000 0.3299549376
WORKING CAPITAL (Current Assets – Current Liabilities) FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity)
Current Assets $35,990,000 Total Assets $74,426,000
Current Liabilities $24,611,000 11379000 Shareholder's Equity $39,851,000 1.8676068355
DEBT RATIO (Total Liabilities / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue)
Total Liabilities $33,302,000 Net Income $3,331,000
Total Assets $74,426,000 0.4474511595 Total Revenue $21,454,000 0.1552624219
EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets)
Net Income $3,292,000 Net Income $3,331,000
Shares Outstanding $3,468,000 0.9492502884 Total Assets $65,021,000 0.0512296027
PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) RETURN ON EQUITY (Net Income – Preferred Dividends / Shareholder's Equity)
Stock Price $265.25 NI – Pref. Div. $3,292,000
EPS $0.95 279.2105263158 Shareholder's Equity $39,851,000 0.0826077137

NPV

Net Present Value (NPV) Calculator
Building
Initial Investment Year 1 2 3 4 5 6 7 8 9 10
Annual Cash Inflows Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Discount Rate NPV = $0 Year 11 12 13 14 15 16 17 18 19 20
Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salvage Value
Equipment
Initial Investment Year 1 2 3 4 5 6 7 8 9 10
Annual Cash Inflows Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Discount Rate NPV = $0 Year 11 12 13 14 15 16 17 18 19 20
Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salvage Value
Bonds
Initial Investment
Annual Cash Inflows
Discount Rate NPV = $0 Year 1 2 3 4 5 6 7 8 9 10
Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Returned

Optional Worksheets->

Monthly

Time Value of Money – Monthly Compounding
Rate of Return Year 1
Initial Investment Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 2
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 3
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 4
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 5
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 6
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 7
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 8
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 9
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Year 10
Month 1 2 3 4 5 6 7 8 9 10 11 12
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Annual

Time Value of Money – Annual Compounding
Rate of Return Year 1 2 3 4 5 6 7 8 9 10
Initial Investment Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

PV

Time Value of Money – Present Value Annuity
Number of Years
Rate of Return $0.00
Payment

FV

Time Value of Money – Future Value Annuity
Number of Years
Rate of Return $0.00
Payment

PV – Lump Sum

Time Value of Money – Present Value of Lump Sum
Rate
Years $0.00
Initial Investment

FV – Lump Sum

Time Value of Money – Future Value of Lump Sum
Rate
Years $0.00
Initial Investment

,

1

FIN 320 Project Two Financial Assumptions When a business needs to invest, it’s important to look at financial options. This is true for simple purchases, such as a new piece of equipment. And it is true for complex purchases, such as a new business. Business leaders must estimate cash flows from an investment and use the net present value (NPV) method to figure out if the investment is worthwhile. Financial Option 1: Purchase a $10 Million Building

Rationale for investment: The business is considering environmental, social, and corporate governance (ESG) factors as part of its investment in a new building for its headquarters. The building itself will be a Leadership in Energy and Environmental Design (LEED)-certified building. However, the new site currently has a large, inactive gas station that sold both gasoline and diesel fuel. The new site also has a large repair facility that was used for deliveries and tractor-trailer trucks for more than 50 years. Some restoration was performed on the site, but the previous owner ran out of funds before they could bring the site up to LEED standards. Four large fuel tanks remain on the site, and they will also need to be addressed per LEED standards. Assumptions to consider:

• $10 million cash purchase

• Building generates additional net profits after tax of $1.25 million per year

• 20 year expected useful life of building

• Salvage value: $1.5 million

• Discount rate is 10%

Financial Option 2: Lease of $25 Million in Equipment

Rationale for investment: The business’s current equipment is efficient, but it uses a lot of electricity. The production line also creates significant waste material, including waste plastics. The business is looking into leasing newer, more environmentally friendly equipment that will still allow it to be at least as efficient in production as it is now. Assumptions to consider:

• Annual cash flows generated with equipment: $4 million

• Discount rate is 12%

• 15-year useful life

• No salvage value

Financial Option 3: $30 Million Investment in Bonds

Rationale for investment: The business is offering these bonds for sale contracts with another business in China to assemble computer parts. The Chinese business has used child labor in the past, but it claims it has stopped this practice. However, the U.S. business selling these bonds has not investigated to verify whether these claims are true.

2

Assumptions to consider:

• 10-year bond

• 8% coupon

• Priced at a discount: $95

• Discount rate is 9%

,

FIN 320 Project Two Financial Analysis Report

[ Note: To complete this template, replace the bracketed text with your own content. Remove this note before you submit your report.]

Financial Analysis and Financial Evaluation

1. Financial Analysis

A. Financial Calculations

Calculate accurate financial formulas to figure out the business’s current financial health. Specifically, calculate the ratios listed below using the Ratios Most Recent Fiscal Quarter (Qtr) and Ratios Same Fiscal Quarter 1 Year Ago worksheets in the Project Two Financial Formulas workbook (linked in the What to Submit section of the Project Two Guidelines and Rubric).

i. Working capital

[Write the result of the calculation and what it says about the company’s health.]

ii. Current ratio

[Write the result of the calculation and what it says about the company’s health.]

iii. Debt ratio

[Write the result of the calculation and what it says about the company’s health.]

iv. Earnings per share

[Write the result of the calculation and what it says about the company’s health.]

v. Price/earnings ratio

[Write the result of the calculation and what it says about the company’s health.]

vi. Total asset turnover ratio

[Write the result of the calculation and what it says about the company’s health.]

vii. Financial leverage

[Write the result of the calculation and what it says about the company’s health.]

viii. Net profit margin

[Write the result of the calculation and what it says about the company’s health.]

ix. Return on assets

[Write the result of the calculation and what it says about the company’s health.]

x. Return on equity

[Write the result of the calculation and what it says about the company’s health.]

B. Working Capital Management

[In one paragraph, explain the impact of working capital management on the business’s operations. Provide examples to support your claims.]

C. Financing

[In one paragraph, explain how a business finances its operations and expansion.]

D. Short-Term Financing

[In one paragraph, explain how potential short-term financing sources could help the business raise funds for improving its financial health. Base your response on the business’s current financial information.]

E. Bond Investment

[In one paragraph, discuss the risks and benefits of the business investing in a corporate bond. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis.]

F. Capital Equipment

[In one paragraph, discuss the risks and benefits of the business investing in capital equipment. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis.]

G. Building

[In one paragraph, discuss the risks and benefits of a business investing in a building. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis.]

2. Financial Evaluation

A. Bond Investment

[In one paragraph, determine if the bond investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to your support claims.]

B. Capital Equipment

[In one paragraph, determine if the capital equipment investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to support your claims.]

C. Building

[In one paragraph, determine if the building investment is a good financing option for the business’s financial health. Use your financial analysis and other financial information to support your claims.]

D. Future Financial Considerations

[In one paragraph, describe the business’s likely future financial performance. Base your description on the business’s current financial well-being and risk levels. Use financial information to support your claims.]

1

Order Solution Now

Categories: