The assignment in this module builds on the idea of forecasting and valuation theory from Chapters 6 and 7 in Module Six by valuing a company through calculations using real data. This will strengthen your recommendation in the final project by giving you the means to provide evidence from a financial analysis. This assignment is worth a total of 100 points. See the points distribution listed with each question.
Prompt
Review the questions below and use the data provided in the question to solve the calculation. As you work through each equation, think about where the data for your company may be found to make the same calculations and how the information from these calculation can inform your recommendations for your final project. Use the non-graded discussion board in this module to ask questions of your peers to inform your responses to the questions below.
This assignment must be submitted as an Excel file.
Purpose of Assignment
Students should understand the mechanics in calculating a company's weighted average cost of capital using the capital asset pricing model (CAPM) and its use in making financial investments.
Assignment Steps
Resources: Tutorial help on Excel
® and Word functions can be found on the Microsoft
®Office website. There are also additional tutorials via the web that offer support for office products.
Scenario: You work for an investment banking firm and have been asked by management of Vestor Corporation (not real), a software development company, to calculate its weighted average cost of capital, to use in evaluating a new company investment. The firm is considering a new investment in a warehousing facility, which it believes will generate an in
Start by reading and following these instructions:
1. Quickly skim the questions or assignment below and the assignment rubric to help you focus.
2. Read the required chapter(s) of the textbook. Some answers may require you to do additional research on the Internet or in other reference sources. Choose your sources carefully.
3. Consider the discussion and the any insights you gained from it.
4. Produce the Assignment submission in a single Microsoft Word or Open Office document. Be sure to cite your sources, use APA style as required, check your spelling.
Assignment:
1. From the following trial balance, identify which statement each title will appear on:
a. Income statement (IS)
b. Statement of owner’s equity (OE)
c. Balance sheet (BS)
Bradford Co.
Trial Balance
Nov. 30, 201X
�
The purpose of the assignment is to develop students' abilities in using datasets to apply the concepts of sampling distributions and confidence intervals to make management decisions.
Assignment Steps
Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set
Review the Payment Time Case Study and Data Set.
Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill payment
Allessandro Scarlatti Company Balance Sheet Partial December 31, 2014
Cash $42,270
Accounts Receivable $96,720
Less: Allowance for doubtful accounts $8960
Inventory $177,630
Prepaid Expenses $9470
Accounts Payable $65,190
Notes Payable $67,510
The following errors in the corporation's accounting have been discovered:
1. January 2015 cash disbursements entered as of December 2014 included payments of account payable in the amount of $40,900, on which a cash discount of 2% was taken.
2. The inventory included $31,600 of merchandise that had been received at December 31 but for which no purchase invoices had been received or entered. Of this amount, $10,900 had been received on consignment; the remainder was purchased f.o.b. destination, terms 2/10, n/30.
3. Sales for the first four days in January 2015 in the amount of $31,620 were entered in the sales journal as of December 31, 2014. Of these, $31,450 were sales on account and the remainder were cash sales.
4. Cash, not in
