FIN 575 Week 5 and 6 Assignments

WEEK 5 TEAM CAPITAL BUDGETING TECHNIQUES

Scenario: A firm has projected free cash flows of $75,000 for Year 1, $100,000 for Year 2, and 125,000 for Year 3, $150,000 for Year 4, and 200,000 for Year 5. The projected terminal value at the end of Year 5 is $400,000. The firm’s Weighted Average cost of Capital (WACC) is 12.0%.

1. Create a Microsoft® Excel® document to determine the Discounted Cash Flow (DCF) value of the firm based on the information provided above. Show calculations.
2. Display your calculations.

WEEK 5 BALANCE SHEET AND CASH FLOW STATEMENT

Purpose of Assignment:

The purpose of this assignment is for students to initiate and complete a comprehensive financial plan. The ultimate result will be a set of pro forma financial statements including an Income Statement, Balance Sheet, and Cash Flow Statement. The student will develop requisite assumptions about the dollar values to be budgeted. We will use the profit and loss statement you created in week four to create the first year balance sheet and cash flow statement for your company.

Assignment Steps:

Assume this is the first year of your business and use the week 4 profit and loss statement from year 1 for the purpose of creating your balance sheet and cash flow statement.

1. Create a properly formatted balance sheet addressing the instructor’s findings from previous class assignment by doing the following: Review the revenue and expense items based on comments made by the instructor, if any, from week four to best estimate realistic values for the balance sheet.
2. Create a properly formatted cash flow statement addressing the instructor’s findings from previous class assignment by doing the following: Review the revenue and expense items based on comments made by the instructor, if any, from week four to best estimate realistic values for the cash flow statement.
3. Conduct an internet search for or use an example located in the textbook as a template to create a properly formatted balance sheet and cash flow statement. I will also provide an example which was posted in class in week four and will repost in week five which shows all three financial statements with sample data and how they are connected and prepared.
4. Explain the order in which the financial statements are prepared and how they are connected.

WEEK 6 DISCUSSION

Respond to the following in a minimum of 175 words:

Organizational budgets assist businesses leaders with awareness of expenditures and managing resources. Businesses use a variety of budgets to measure their spending and develop effective strategies for maximizing their assets and revenues. Organizational budgets are generally designed to meet specific needs of the organization.

• Discuss the benefits that may be achieved by creating a business budget.
• Discuss the likely organizational problems that may arise from not creating a business budget.

SOURCES AND USES OF BUSINESS FINANCING PAPER

Assignment Steps:

Resource: The U.S. Small Business Administration (SBA) website is perhaps the most valuable resource for any new entrepreneur in America for all aspects of starting, operating, and growing a business, and it would help the students in this class to use it like a handbook. It is especially useful in learning more about financing a business and obtaining a loan.

Assess stages of financing in a minimum 1,200 words which includes the following:

1. How can the SBA website help with financing (use the SBA website).
2. What resources does the SBA website provide to the entrepreneur.
3. Explain the different stages of financing.
4. Analyze sources of financing through the life cycle of a firm.
5. Assess the trade-offs between debt and equity financing for an entrepreneur.

Cite a minimum of one peer reviewed reference from the University Library.