{"id":433227,"date":"2018-04-09T06:16:16","date_gmt":"2018-04-09T06:16:16","guid":{"rendered":"https:\/\/essaypaper.org\/time-value-of-money-opportunity-cost-and-income-taxes-worksheet\/"},"modified":"2018-10-24T08:52:11","modified_gmt":"2018-10-24T08:52:11","slug":"time-value-of-money-opportunity-cost-and-income-taxes-worksheet","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/time-value-of-money-opportunity-cost-and-income-taxes-worksheet\/","title":{"rendered":"Time Value of Money, Opportunity Cost, and Income Taxes Worksheet"},"content":{"rendered":"
\n

Time Value of Money, Opportunity Cost, and Income Taxes Worksheet<\/p>\n

Scenario 1:Time Value of Money \/ Cash Management Products<\/strong><\/p>\n

    \n
  1. Use this Bankrate\u2019s Simple Savings calculator to complete Scenario 1: http:\/\/www.bankrate.com\/calculators\/savings\/simple-savings-calculator.aspx. You will enter the Initial Amount of Savings (Present Value), Annual Interest Rate (Rate of Return), and Number of Periods\/Yearsinto the calculator. The calculator will compute the Future Values.<\/li>\n<\/ol>\n

    \u00a0<\/p>\n

    In this scenario you will look at the impact of interest rates on your savings.Suppose that you have $2,000 of savings.\u00a0You don\u2019t anticipate needing to dip into these funds in the next five years.\u00a0Based on the information provided in the table, calculate the future value (FV) of $2,000 at the end of years 1 and 5 if it were to be completely invested in each of the different cash management products.<\/p>\n

    \u00a0<\/p>\n

    Enter your answers in the indicated cellsof the table below. The Restrictions\/Fees on Product Usage column relates to question 2 of Scenario 1.<\/p>\n

    \u00a0<\/p>\n\n\n\n\n\n\n
    Product<\/strong><\/td>\nAnnual Interest Rate<\/strong><\/td>\nRestrictions\/Fees on Product Usage<\/strong><\/td>\nFV at end of Year 1<\/strong><\/p>\n

    \u00a0<\/p>\n<\/td>\n

    		FV at end of Year 5<\/strong><\/p>\n

    \u00a0<\/strong><\/p>\n<\/td>\n<\/tr>\n

    Checking Account<\/strong><\/td>\n0.00%<\/td>\n\u00b7\u00a0\u00a0 No minimum<\/p>\n

    \u00b7\u00a0\u00a0 No limit on withdrawals<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n<\/td>\n<\/tr>\n

    Savings Account<\/strong><\/td>\n1.50%<\/td>\n\u00b7\u00a0\u00a0 No minimum<\/p>\n

    \u00b7\u00a0\u00a0 Limited to 3 withdrawals per month<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n<\/td>\n<\/tr>\n

    Certificate of Deposit (CD)<\/strong><\/td>\n5%<\/td>\n\u00b7\u00a0\u00a0 $500 minimum balance<\/p>\n

    \u00b7\u00a0\u00a0 Early withdrawal penalty: 180 days of interest plus $25<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n<\/td>\n

    		Answer:<\/p>\n

    \u00a0<\/p>\n

    Inputs<\/u>:<\/p>\n

    Interest Rate per Time Period:<\/p>\n

    Number of Time Periods:<\/p>\n

    Present Value:<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

      \n
    1. Based on your calculations and on all you have learned this week, how would you choose to save your $2,000?\u00a0Consider things such as rate of return, inflation, taxes, liquidity, safety, restrictions, and fees, and explain the rationale for your decision.\u00a0Respond in at least 50 words.<\/li>\n<\/ol>\n

      \u00a0<\/p>\n

      <Write response here.><\/p>\n

      \u00a0<\/strong><\/p>\n

      Scenario 2:Time Value of Money \/ Compounding Interest<\/strong><\/p>\n

      \u00a0<\/p>\n

        \n
      1. Use this Bankrate\u2019s Simple Savings calculator to complete Scenario 2: http:\/\/www.bankrate.com\/calculators\/savings\/simple-savings-calculator.aspx.You will enter the Initial Amount of Savings (Present Value), Annual Interest Rate (Rate of Return), Interest Compounded, and Number of Periods\/Years into the calculator. The calculator will compute the Future Values.<\/li>\n<\/ol>\n

        In this scenario you will start with a big deposit and see how interest, compounding, and time will change the balance over time.Suppose that you inherit $10,000 from your late uncle.You save this money and do not deposit any more money to the account. Determine how much money you would have at the end of each of the periods for each of the scenarios in the table below, assuming that you don\u2019t make any withdrawals from the account over the period.<\/p>\n

        \u00a0<\/p>\n

        Enter your answers in the indicated cellsof the table below:<\/p>\n

        \u00a0<\/p>\n\n\n\n\n\n\n\n
        \u00a0Annual Interest Rate<\/strong><\/td>\nInterest Compounded <\/strong><\/td>\nFV at the end of Year 5<\/strong><\/td>\nFV at the end of Year 10<\/strong><\/td>\nFV at the end of Year 30<\/strong><\/td>\n<\/tr>\n
        2.00%<\/td>\nAnnually<\/td>\nAnswer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n<\/tr>\n

        2.00%<\/td>\nQuarterly<\/td>\nAnswer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n<\/tr>\n

        8.00%<\/td>\nAnnually<\/td>\nAnswer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n<\/tr>\n

        8.00%<\/td>\nQuarterly<\/td>\nAnswer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n

        		Answer:<\/p>\n

        \u00a0<\/u><\/p>\n

        \u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/p>\n

          \n
        1. Based on your calculations above, explain in your own words the impact of compounding interest.<\/li>\n<\/ol>\n

          \u00a0<\/p>\n

          <Write response here.><\/p>\n

          \u00a0<\/p>\n

          \u00a0<\/strong><\/p>\n

          Scenario 3:Cost of Credit\/Opportunity Cost\/Trade-Offs<\/strong><\/p>\n

          \u00a0<\/p>\n

            \n
          1. In this scenario you will calculate the monthly payment and total interest paid on a car loan.Suppose that you need $15,000 to buy a used vehicle to get back and forth\u00a0to work and school.\u00a0You have $7,500 in a money market fund earning 1.00% per year, but you are not sure you want to use any or all of that money.<\/li>\n<\/ol>\n

            \u00a0<\/p>\n

            Using the tables in Exhibit 1-D, located on pp. 42-43 in the Ch. 1 Appendix of Focus on Personal Finance<\/em>, determine the\u00a0total amount of payment due at the end of each year, and divide by 12 to estimate the\u00a0monthly payment for each of the following loan scenarios.\u00a0Also, calculate the total amount of interest you would pay over the life of each loan.\u00a0Be sure to show your work for opportunities to earn partial credit, where applicable.<\/p>\n

            \u00a0<\/p>\n

            For example, if you have the correct formula but put a decimal in the wrong spot you could earn partial credit. The first row in the table has been completed to demonstrateyou how work can be shown.<\/p>\n

            \u00a0<\/p>\n\n\n\n\n\n\n\n
            Loan Amount<\/strong><\/td>\nInterest Rate<\/strong><\/td>\nTerm<\/strong><\/td>\nMonthly Loan Payment<\/strong>= Amount Borrowed divided by \u201cTable Factor in Exhibit 1-D\u201d divided by 12<\/td>\nTotal Amount of Interest<\/strong>\u00a0= (Monthly Loan Payment * Term * 12) \u2013 Loan Amount<\/td>\n<\/tr>\n
            $7,500<\/td>\n6%<\/td>\n3 years<\/td>\nExample:<\/p>\n

            7500\/2.673=2,805.84<\/strong><\/p>\n

            2,805.84\/12=\u00a0233.82<\/strong><\/p>\n

            \u00a0<\/p>\n<\/td>\n

            		Example:<\/p>\n

            (233.82*3*12) \u2013 7,500=\u00a0917.52<\/strong><\/p>\n

            \u00a0<\/p>\n<\/td>\n<\/tr>\n

            $7,500<\/td>\n6%<\/td>\n5 years<\/td>\n\u00a0<\/p>\n

            \u00a0<\/p>\n<\/td>\n

            		\u00a0<\/td>\n<\/tr>\n
            $10,000<\/td>\n6%<\/td>\n5 years<\/td>\n\u00a0<\/p>\n

            \u00a0<\/p>\n<\/td>\n

            		\u00a0<\/td>\n<\/tr>\n
            $15,000<\/td>\n6%<\/td>\n5 years<\/td>\n\u00a0<\/p>\n

            \u00a0<\/p>\n<\/td>\n

            		\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            \u00a0<\/p>\n

              \n
            1. Based on the above calculations, the price of the car, and the money available in a money market fund, which loan option would you suggest to someone purchasing a vehicle?\u00a0Please\u00a0explain the rationale\u00a0and considerations\u00a0for your decision.<\/li>\n<\/ol>\n

              \u00a0<\/p>\n

              <Write response here.><\/p>\n

              \u00a0<\/p>\n

                \n
              1. In your own words, how would you summarize \u201copportunity cost\u201d? How does the concept of opportunity cost apply to this decision? Explain in a brief paragraph.<\/li>\n<\/ol>\n

                <Write response here.><\/p>\n

                Income Taxes<\/strong><\/p>\n

                \u00a0<\/p>\n

                Each year you will need to file a federal income tax return by April 15th<\/sup>.\u00a0While you may use software or a tax preparation professional to help you complete your return, there are still some terms of which you should have a basic understanding.\u00a0Respond to the following to demonstrate your understanding.\u00a0Each response should be at least 50 words.<\/p>\n

                \u00a0<\/p>\n

                  \n
                1. Explain the differences between\u00a0taxable income<\/strong>and\u00a0adjusted gross income<\/strong>.<\/li>\n<\/ol>\n

                  \u00a0<\/p>\n

                  <Write response here.><\/p>\n

                  \u00a0<\/p>\n

                    \n
                  1. In your own words, definetax deduction, exemption<\/strong>, and\u00a0tax credit.<\/strong><\/li>\n<\/ol>\n

                    \u00a0<\/p>\n

                    <Write response here.><\/p>\n

                    \u00a0<\/p>\n

                    <\/p>\n

                    \n
                    \n <\/p>\n
                    \nwhat people say
                    \n
                    \n
                    \nLeave your rating
                    \n<\/em>
                    \n<\/span>
                    \n<\/p>\n

                    \nSort by: <\/span>
                    \n