FIN 571 Week 1 Connect Problems ( Week 1 Problem Set )
3 . You are working on an Excel table and realize that you need to delete a column in the middle of your table and shift the remaining data columns to the left . What is one way to do this ? 4 . You are valuing an investment that will produce cash flows of $ 10,000 each year for 15 years . What is the quickest way to enter $ 10,000 into each of the 15 cells of your table ? 5 . You have three tables in a worksheet in Excel . You need to sort one of the tables numerically , from smallest to largest values . How can you do this ? 9 . Solving for the Unknown This lesson will help you review how to solve for unknown quantities in a problem . 1 . If the future value of a one-period investment is given by the formula , F = I + ( I × R ), what is the formula for the amount of the investment , I ? 2 . The opposite process rule says to solve for ________. 3 . When solving for an unknown that involves more than one process , the multiple process rule requires that ________. 4 . If the future value of a one-period investment is given by the formula , F = I + ( I × R ), what is the formula for the rate of interest , R ? 5 . If the bank returns $ 50 on a $ 1,000 deposit after one year , what is the interest rate earned on this deposit ? 10 . Accounting Concepts This lesson will help you refresh the basic accounting concepts . 1 . ________ are items owed to a creditor . ________ are items owned by a company . ________ represents owners ' claims to company resources . 2 . Under ________ accounting , revenues are recorded when earned and expenses are recorded with related revenues . Under ________ accounting , revenues are recorded when cash is received and expenses are recorded when cash is paid out . Financial statements are prepared using ________ accounting . 3 . The ________ retains the power and authority to set accounting standards . Currently , this responsibility has been delegated to the ________. 4 . In what order are the four primary financial statements prepared ? 5 . The difference between net income and dividends paid is known as what ? *************************************************************************************
FIN 571 Week 1 Connect Problems ( Week 1 Problem Set )