Unit 1 Assignment: Writing Assignment This Assignment requires that you view three videos. Two of these videos will introduce you to methods of calculation, using a calculator, and using Excel. The third video is an introduction to finance in addition to providing some practical advice that will help you to reflect on how this course will benefit you. This Assignment will assess your knowledge based on the following outcome: MT217-1: Please review these required videos:  Use Excel to solve Example Problem 1.1  See what keystrokes are needed to solve Problem 1.1  Four Facets of Finance- Explain It! Assignment Instructions: Select the Assignment link in the left navigation under Unit 1 to watch the assigned videos. Select Submit after watching each video and reflect on how learning how to use Excel and a financial calculator to learn finance will assist you with your personal goals or as a business manager. Use Microsoft Word to write a paper for this Assignment and answer the questions listed below: 1. Describe in detail the goals you have for this unit. 2. Describe how this unit will help you in your professional development.3. After viewing the videos, what are the three most important concepts you learned? 4. How would learning how to use Excel and a financial calculator assist you with your personal goals or as a business manager? Assignment Checklist:  Write your original response in Standard English, paying special attention to grammar, style, and mechanics.  Respond to the questions in a thorough manner, providing specific examples of concepts, topics for each question.  Ensure that your viewpoint and purpose are clearly stated.  Demonstrate logical and appropriate transitions from one idea to another.  Make sure to address the critical elements listed above and in the grading Rubric so you can demonstrate your competence of the above outcomes you will be assessed on.  Your paper should be highly organized, logical, and focused.Rubrics : Directions for submitting your Assignment submit your minimum 1 page response Described in detail the goals for this unit. 4 points Described how this unit will help with professional development. 4 Discussed the three most important concepts learned from the videos. 4 Explained how to use Excel and a financial calculator assists with personal and career goals. 4 Analysis Work demonstrates synthesis of concepts, research, and experience. 4 Work demonstrates the student’s ability to tie relevant information to real life applications. 4 Analysis exceeds basic comprehension to demonstrate higher order thinking. 4 Writing Correct use of APA 6th edition format; all sources used to support the paper are referenced. 2 Sentences are clear, concise, and direct; tone is appropriate. 2 Spelling, grammar, and punctuation are correct. 2

AD 632 Financial ConceptsNon-CONNECT HomeworkFinancial Calculator1)Abby wants to purchase a new car that will cost $24,000. She will make a down payment of $2,500 and will borrow the rest. The annual interest rate on the loan is 4.65%. The monthly principle and interest payments will be $350.00. How many monthly payments will Abby have to make to pay off the car loan?Which model financial calculator are you using___________________________NiPVPMTFV2)Judy needs to purchase some new appliances for her new condo. The appliances will cost $1,640. The store is offering a special for the financing of the appliances. The terms are 24 months with a minimum monthly payment of $90. What annual interest rate is Judy being charged?NiPVPMTFV3)Steven wants to save for a family vacation in 3 years. The cost of the vacation will be $16,500. He plans to invest in a mutual fund that will earn 7.2% annually. To reach his goal, how much does Steven need to invest today?NiPVPMTFV4)Meredith wants to begin a retirement savings account. She plans on retiring in 42 years and wants to accumulate $2,200,000 by the time she retires. If she is just beginning her savings and can earn 9.2% on her investments, how much will she need to save each month?NiPVPMTFV5)Wil just learned that 72 years ago his aunt left him $7,500 in an investment which paid 4.8% annual interest. What is the value of that investment today?NiPVPMTFV6)Aubrey has an opportunity to invest $10,000 in a Certificate of Deposit (CD) that will pay her 2.78% annually. When the CD matures in 6 years, how much will Aubrey receive? Note: CD’s only pay interest at the end of the period.NiPVPMTFV7)Assume the same facts as in 6) above, except the interest will be compounded semi-annually. When the CD matures in 6 years, how much will Aubrey receive?NiPVPMTFV8)Assume the same facts as in 6) above, except the interest will be compounded monthly. When the CD matures in 6 years, how much will Aubrey receive?NiPVPMTFV9)Evan purchased a house and obtained a $380,000 fully amortized level payment 15-year mortgage. The mortgage’s annual interest rate is 4.82%. What will be Evan’s monthly blended principal and interest payment?NiPVPMTFV10) Using the information from 9) above, determine how much of the total payment is principal? And how much of the total payment is interest? Prepare the amortization table for months 1, 2, and 3BeginningAmortizationEndingMonthPrincipalPaymentInterestof PrinciplePrinciple123