FIN 571 Week 1 Connect Problems (Math Accounting Review) -...

This preview shows page 1 - 5 out of 17 pages.

Math & Accounting Review1.Award:10 out of 10.00 pointsShow correct answerFunctionsExcel will make your life as a finance student much easier. This section will show how to use variousfunctions in Excel. Once you understand the how and why of a particular financial equation, you can makeuse of different functions in Excel to solve problems quickly. Brushing up on these concepts now will helpyou tackle your finance coursework later.Press play to watch the first presentation below. Click on the numbers to navigate through the lesson, andthen complete the Concept Check at the end to cement your skills and receive credit.
2. Which statements about Excel’s FV function are correct?
* 3. Which fields are required to calculate net present value (NPV) in Excel?
Future value and rate of returnCash flows for each year and average cash flow* 4. Which Excel function is used to calculate the amount of each annuity payment?
* 5. Which fields are required to calculate the rate of return (RATE) for a present value calculation inExcel?
2.Award:10 out of 10.00 pointsShow correct answerThe Balance SheetThis lesson will help you refresh your knowledge on the basics of the balance sheet. Brushing upon these concepts now will help you tackle your finance coursework later.Press play to watch the first presentation below. Click on the numbers to navigate through thelesson, and then complete the Concept Check at the end to cement your skills and receive credit.
General Ledger for XYZ CompanyThe following is a portion of the general ledger for XYZ Company as of December 31,20X1, and the statement of stockholders’ equity for XYZ Company for the yearended December 31, 20X1. Use this information to answer questions (1) through (5).XYZ CompanyStatement of Stockholders' Equity (partial)For the year ended December 31, 20X1CommonStockRetainedEarningsBalance at January 1, 20X1$50,000$63,000Issuance of common stock32,000+ Net income for the year ended12/31/X114,000- Dividends paid(4,900)Balance at December 31, 20X1$_______$_______XYZ CompanyGeneral Ledger (partial)As of December 31, 201XAmountAssetsCash$ 53,000Accounts receivable15,000Supplies8,800Prepaid rent36,000Equipment (net)115,600LiabilitiesAccounts payable$11,300Salaries payable2,500Interest payable1,900Utilities payable6,900Bonds payable51,700* 1. What is the total amount of current assets to be reported on XYZ Company’s12/31/X1 classified balance sheet?
$228,400$76,800* 2. What is the total amount of long-term assets to be reported on XYZ Company’s

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 17 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
DR.SHERMAN

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture