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...
-
An integrated test facility (ITF) is a method used by both internal and external auditors for testing IT-based system controls. Discuss the advantages and disadvantages of implementing an ITF.
-
A rectangular waveguide is filled with polyethylene ( = 2.25o) and operates at 24 GHz. If the cutoff frequency of a certain TE mode is 16 GHz, find the group velocity and intrinsic impedance of the...
-
According to the Supreme Court decision in Quill Corp. v. North Dakota, a state may not require a retailer with no physical presence in the state to collect and remit sales tax on sales made in the...
-
Entries for Held-to-Maturity Securities on January 1, 2009, Roosevelt Company purchased 12% bonds, having a maturity value of $500,000, for $537,907.40. The bonds provide the bondholders with a 10%...
-
Briefly describe TWO (2) drawbacks of NoSQL in comparison with RDBMS ?
-
Paoli Consulting is a consulting firm owned and operated by Mary Paoli. The following end-of-period spreadsheet was prepared for the year ended March 31, 2019: During the year ended March 31, 2019,...
-
20. The molecular formula for hydrogen peroxide is HO. Please draw the structural formula (as a Lewis diagram) to indicate that you understand the molecule. (i) Lewis Diagram: explain (ii) What is...
-
What is inflation? Was it a problem during colonial times? When does inflation negatively impact income and wealth? When does it ease problems of debtors against creditors? When does it encourage...
-
If demand for built space in real estate is declining, does this imply that real rents (that is, rents measured net of inflation) will fall in the market? Why or why not? As in the previous question,...
-
Todd is a cattle rancher. In June and July he spent his clothing budget on jeans and cowboy hats. Each pair of jeans cost $56 and each hat cost $41. At Todd's optimal choice, his marginal utility...
-
Joe's Pizza has an elasticity of separations (quits) with respect to the wage of -0.5. What is the labor supply elasticity facing Joe's Pizza? How does this compare to a perfectly competitive labor...
-
A health economist was asked to compare outcomes and costs of two prophylactic medicines that reduced deaths during surgical operations. The interventions did not influence quality of life. What...
-
Hiring can involve a complex series of tasks. HR personnel must be cognizant of all the laws that apply when going through this process, otherwise they can subject their employer to lawsuits....
-
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,...
-
Using all the tips presented in this chapter, write your rsum. Aim it at a full-time job, part-time position, or internship that you researched online. Attach the job listing to your rsum. Also...
-
What is the imperative mood, and why is it preferred over the indicative mood?
-
Can workers today be successful if their writing is and remains poor? What could be the career fallout for someone who is unwilling or unable to train to become a better communicator?
Study smarter with the SolutionInn App