Use data you find online to respond to the following items. Cite the page or pages...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use data you find online to respond to the following items. Cite the page or pages where you obtain this information by including a citation list at the end of your presentation which includes the site's URL and page title. 1. Provide, in visual format, any data, tables, or charts you use during the creation of your presentation. Tables, charts, and items listed below should all be present in a powerpoint presentation you will make for the class. Tables and charts should be detailed and informative and not be 'slapdash' creations. 2. Use the following information to determine the Davidsons' monthly cash flow: Gary and Michelle Davidson currently have 2 children (ages 9 and 7) and a golden retriever dog. Gary works as a manager at a local manufacturing plant. His current annual salary is $59,400. A Each month, Gary's payroll deductions include $367.45 for federal income tax, $162.50 for state income tax, and $378.68 for their FICA (Social Security and Medicare) tax. Currently $34.17 is being deducted and deposited into their 401k. . . . . Their current MasterCard balance is $4.730 and is being assessed an 18% APR finance charge and they have a minimum payment of $95 monthly. The family bought a home 5 years ago for $250,000. Their loan is for 30 years at a fixed rate of 6% APR and their monthly payment is $1,349. To safeguard against theft, fire, and other calamities, they carry homeowner's insurance with an annual premium of $984. The Davidsons pay $675 every six months for property taxes on their home and lot. They currently pay a monthly cable TV bill of $65.49, a landline phone bill of $32.50, and internet provider bill of $43.68, and a cellphone bill of $109.45. Their utility bills for electricity, natural gas, and water/sewer/garbage are $39.56, $89.75, and $53.49 respectively. • The Davdisons are a two vehicle family. They own an older mini-van that is paid for, but recently purchased a new Ford F-150. They had to borrow $30,000 at 7% APR, which resulted in a $586 monthly payment. They have estimated that they spend about $360 per year on vehicle maintenance and their vehicle insurance premium is $468 every six months. Lately, they have been averaging about $150 per month on gasoline for the van and truck combined. . Because the family rarely plans out their weekly meals or uses coupons $635 is a typical monthly average on groceries. They eat out quite often and spend about $125 at restaurants. Both Gary and Michelle belong to a local health club and spend $48 per month on membership dues, their clothing expenditures average about $90 for the family, entertainment is $65, household supplies about $35, miscellaneous items $70, and their monthly dog food and vet bills for their golden retriever average about $42. They also pay make $60 in charitable contributions each month. Finally, the Davidsons are doing their best to protect the family with health and life insurance policies. Currently they pay $197.89 towards health insurance each month, and $47.82 towards life insurance each month. 3. Suggest some immediate areas where the Davidsons can improve their monthly cashflow. Be specific. 4. One possibility, currently being investigated by the Davidsons, is a refinancing of their home. Create an amortization table that shows how much principle remains on their original home loan as of today. (See example 1 and example 2, in section 4D). Create a table showing how much remains to be paid after each year, through year 5. 5. A bank will allow them to refinance the remaining balance on their home, along with their credit card balance. What would be the starting principle of this loan? 6. The Davidsons are offered the following loan options for their refinance: 15 years at at a fixed rate of 3.7% APR, or 30 years at a fixed rate of 4% APR. Determine the monthly payment of the loan in either instance. 7. Advise the Davidsons on which loan option they should consider taking if they want to maximize their monthly cashflow as a result of the refinance. 8. Mr. Davidson is concerned about the total amount of interest they would pay on each of the new loans. Determine the total interest they would pay in either case. 9. The value of the F-150 has decreased 20% from their original purchase price. If they sold the F-150 for this amount and used the sale price as a down payment on their home refinance loan (with the credit card debt included in the loan), what would the new monthly payment be in both the and 30-year scenarios in item # 6? 10. What would happen to the total interest owed on the home refinance loan if the starting principle was reduced by the sale price of the F-150, as illustrated in item #9? 11. Discuss some of the benefits to making a monthly budget, and how much the Davidsons could improve their monthly cashflow by following some of the suggestions illustrated in items # 3-#10. Use data you find online to respond to the following items. Cite the page or pages where you obtain this information by including a citation list at the end of your presentation which includes the site's URL and page title. 1. Provide, in visual format, any data, tables, or charts you use during the creation of your presentation. Tables, charts, and items listed below should all be present in a powerpoint presentation you will make for the class. Tables and charts should be detailed and informative and not be 'slapdash' creations. 2. Use the following information to determine the Davidsons' monthly cash flow: Gary and Michelle Davidson currently have 2 children (ages 9 and 7) and a golden retriever dog. Gary works as a manager at a local manufacturing plant. His current annual salary is $59,400. A Each month, Gary's payroll deductions include $367.45 for federal income tax, $162.50 for state income tax, and $378.68 for their FICA (Social Security and Medicare) tax. Currently $34.17 is being deducted and deposited into their 401k. . . . . Their current MasterCard balance is $4.730 and is being assessed an 18% APR finance charge and they have a minimum payment of $95 monthly. The family bought a home 5 years ago for $250,000. Their loan is for 30 years at a fixed rate of 6% APR and their monthly payment is $1,349. To safeguard against theft, fire, and other calamities, they carry homeowner's insurance with an annual premium of $984. The Davidsons pay $675 every six months for property taxes on their home and lot. They currently pay a monthly cable TV bill of $65.49, a landline phone bill of $32.50, and internet provider bill of $43.68, and a cellphone bill of $109.45. Their utility bills for electricity, natural gas, and water/sewer/garbage are $39.56, $89.75, and $53.49 respectively. • The Davdisons are a two vehicle family. They own an older mini-van that is paid for, but recently purchased a new Ford F-150. They had to borrow $30,000 at 7% APR, which resulted in a $586 monthly payment. They have estimated that they spend about $360 per year on vehicle maintenance and their vehicle insurance premium is $468 every six months. Lately, they have been averaging about $150 per month on gasoline for the van and truck combined. . Because the family rarely plans out their weekly meals or uses coupons $635 is a typical monthly average on groceries. They eat out quite often and spend about $125 at restaurants. Both Gary and Michelle belong to a local health club and spend $48 per month on membership dues, their clothing expenditures average about $90 for the family, entertainment is $65, household supplies about $35, miscellaneous items $70, and their monthly dog food and vet bills for their golden retriever average about $42. They also pay make $60 in charitable contributions each month. Finally, the Davidsons are doing their best to protect the family with health and life insurance policies. Currently they pay $197.89 towards health insurance each month, and $47.82 towards life insurance each month. 3. Suggest some immediate areas where the Davidsons can improve their monthly cashflow. Be specific. 4. One possibility, currently being investigated by the Davidsons, is a refinancing of their home. Create an amortization table that shows how much principle remains on their original home loan as of today. (See example 1 and example 2, in section 4D). Create a table showing how much remains to be paid after each year, through year 5. 5. A bank will allow them to refinance the remaining balance on their home, along with their credit card balance. What would be the starting principle of this loan? 6. The Davidsons are offered the following loan options for their refinance: 15 years at at a fixed rate of 3.7% APR, or 30 years at a fixed rate of 4% APR. Determine the monthly payment of the loan in either instance. 7. Advise the Davidsons on which loan option they should consider taking if they want to maximize their monthly cashflow as a result of the refinance. 8. Mr. Davidson is concerned about the total amount of interest they would pay on each of the new loans. Determine the total interest they would pay in either case. 9. The value of the F-150 has decreased 20% from their original purchase price. If they sold the F-150 for this amount and used the sale price as a down payment on their home refinance loan (with the credit card debt included in the loan), what would the new monthly payment be in both the and 30-year scenarios in item # 6? 10. What would happen to the total interest owed on the home refinance loan if the starting principle was reduced by the sale price of the F-150, as illustrated in item #9? 11. Discuss some of the benefits to making a monthly budget, and how much the Davidsons could improve their monthly cashflow by following some of the suggestions illustrated in items # 3-#10.
Expert Answer:
Answer rating: 100% (QA)
Statement of monthly net cash flow of Gary Particulars Monthly Salary A Tax deducctions Federal Inco... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Use the income statement to respond to the following items: CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands Jan. 31, 2021 Feb. 02, 2020 Current assets Cash and cash equivalents $ 1,150,517 $...
-
You need to respond to the following topics: Prompt 1: Employment Resources Prompt 2: New Ideas in Job Seeking Prompt 3: Audience Adaptation in the Job Search Prompt 4: STAR Technique for Interview...
-
Outline a paper to respond to the following discussion: Using the Affordable Care Act policy recommendation that the Republicans and Democrats could sit down and negotiate their differences about the...
-
An amplifier has three cascaded stages of amplification, each having available power gain of 10 dB and noise figure of 3 dB. i) ii) Calculate the noise factor (ratio), and noise figure (dB). If the...
-
How are external and internal agents modeled in REA diagrams for transactions that involve purely internal exchanges, such as raw material moving into production?
-
Mr. and Mrs. Poe earned $115,900 compensation income and $963 interest this year and recognized a $600 short-term capital gain and a $7,200 long-term capital gain on the sale of securities. They...
-
Sherman Lawn Service, Inc., began operations and completed the following transactions during August: Aug 1 Received \($1,000\) and issued 100 shares of common stock. Deposited this amount in bank...
-
Coca-Cola markets PowerAde as a sports drink that competes with Gatorade. Competition for sports drinks is fierce where they are sold in the coolers of convenience stores. Coca-Cola is thinking about...
-
Why Implementing internationalization strategy is an important? What are the opportunity and benefits for the company? Please include the source of the info including the link thank you.
-
Segment the wind-generated power industry in a way that shows where Windspire Energy, the subject of the You Be the VC 1.1 feature, is located in the industry. How does Windspires awareness of the...
-
Write an essay about Sex education should be made mandatory in schools
-
Fill in the table below for the following zero-coupon bonds, all of which have par values of $1,000. Use semi-annual periods. (Do not round intermediate calculations. Round your answers to 2 decimal...
-
Focus on the North American Free Trade Agreement (NAFTA), which became the United States -- Mexico -- Canada Agreement (USMCA) as of July 1, 2020. Begin with reading pages 271-274 (Regional Economies...
-
I must answer questions regarding the movie my cousin Vinny and answer some of these questions. Name the movie and the year the movie was produced. What is the main plot of the movie? Briefly state...
-
Drawing from one or more of the key themes identified in the Stanford text (pg 399-402). Read the Stanford text Economics for Everyone (2nd ed.) and highlight five things from the book and how they...
-
What amount will Mary need to invest now if she can earn 6.5% compounded annually if she wants to have $6812 amount in 7 years? Answer:
-
1.What are the four (4) steps in conducting a Market Research Process? 2. In Market Research, what are the 3 types of research? Briefly explain each. 3. What are the six (6) steps in Implementing the...
-
Smiths Family Fashions implemented a balanced scorecard performance measurement system several years ago. Smiths is a locally owned clothing retailer with fashions for men, women, teens, and...
-
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
-
Frank, age 35, and Joyce, age 34, are married and file a joint income tax return for 2012. Their salaries for the year total $83,000 and they have taxable interest income of $4,000. They have no...
-
Abigail (Abby) Boxer is a single mother working as a civilian accountant for the U.S. Army. Her Social Security number is 676-73-3311 and she lives at 3456 Alamo Way, San Antonio, TX 78249. Helen,...
-
The W250 \(\times 28\) A-36 steel column is fixed at its base. Its top is constrained to rotate about the \(y-y\) axis and free to move along the \(y-y\) axis. Determine the force \(\mathbf{P}\) and...
-
The W250 28 A-36 steel column is fixed at its base. Its top is constrained to rotate about the \(y-y\) axis and free to move along the \(y-y\) axis. If \(e=350 \mathrm{~mm}\), determine the allowable...
-
The W14 \(\times 53\) column is fixed at its base and free at its top. Determine the maximum eccentric load \(P\) that it can support without causing it to buckle or yield. Take \(E_{\mathrm{st}}=\)...
Study smarter with the SolutionInn App