Trevor and Kristen Hill need to prepare a cash budget for thenext three months to make sure that they can cover theirexpenditures during the period. Trevor and Kristen havetracked their finances for the past few years using an app, andthus know what percentage of their take-home pay of $5500goes for various expenses.ExpensesHousingUtilitiesFoodTransportationMedical/dentalContributionsClothing (3% normally; $450 in Month 3)Property Taxes ($1260, Month 2 only)AppliancesPersonal CareTravel and Entertainment (6%; $1400 in Month 3)OtherSavings29.0%5.0%9.5%6.0%5.0%10.5%3.0%a.1.0%2.0%6.0%5.0%7.5%The Hills must maintain a $1500 cash balance to avoidchecking fees; however, the balance on March 31, 2021 was$1300. Their savings account balance on March 31 was$20,000.Prepare a quarterly cash budget for Trevor and Kristenfor the next three months.b. Using your calculations, show the monthly inflows andoutflows and the end-of-month balances for the Hillschecking account.c. In what months do the Hills run a deficit? A surplus?d. What is your analysis of the Hills' budget?

As per Bartleby Guidelines if Multiple Subpart Questions are asked then the Expert needs to answer…

Answered: Trevor and Kristen Hill need to prepare…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. Seth and Ann are looking at four different homes. They created a spreadsheet to estimate escrow calculations more easily. They will pay the property tax and homeowner's insurance each month with their mortgage payment. The bank will hold these two amounts in escrow until those bills need to be paid, which is every six months. Each line represents data for a different home they are looking at. Calculate their monthly escrow payment for these four houses. Monthly Annual Semi-Annual Monthly Escrow Payment Mortgage Property Homeowner's Таx Insurance 2,134 6,390 750 2, 456 7,543 700 2, 857 8,765 800 2,256 8,950 650
Ralph has two accounts with South Trust National Bank. Over the summer, he mows lawns and deposits his earnings weekly into his savings account. Ralph also eats out every day and uses the money in his checking account to pay for his meals. Besides these two transactions, he does not deposit or withdraw funds from either of these accounts.The amount in his savings account over time is represented in the table below. He spends$50 on food each week, and after three weeks, he has $1,600 in his checking account. Ralph Saving Account Weeks Total Amount 0 2 700 6 1100 12 1700 Part A How much money was in his saving account initially (at week zero)? Show how you determine your answer. Part B Create an equation to model Ralph’s savings account and create another equation to model Ralph’s checking account. After how many weeks will he have more money in his saving account?
In addition to these monthly expenses, other future outlays must be accounted for. Before they had a child, Yvette worked as a software engineer, but her knowledge and skills are now somewhat outdated. Therefore, they include $25,000 for Yvette to go back to school. Additionally, Tim and Yvette want to create a college fund of $30,000 to fund their child's college education. They estimate that final expenses (funeral costs and estate taxes) will amount to $12,000. Finally, they have taken out a loan for home improvements of $130,000 and an automobile loan of $5,000. They own their home but still have an outstanding mortgage of $300,000. Using this information, complete the next portion of Step 1 to determine the total financial resources needed. 2. Special needs a. Spouse's education fund b. Child's college fund c. Other needs $0 3. Final expenses (funeral costs and estate taxes) 4. Debt liquidation a. House mortgage b. Other loans c. Total debt (4a+4b) 5. Other financial needs $0…
This year Evan graduated from college and took a job as a deliveryman in the city. Evan was paid a salary of $78,300 and he received $700 in hourly pay for part-time work over the weekends. Evan summarized his expenses as follows: Cost of moving his possessions to the city (125 miles away) Interest paid on accumulated student loans Cost of purchasing a delivery uniform Contribution to State University deliveryman program $1,200 3,000 1,600 1,400 Calculate Evan's AGI and taxable income if he files single. Assume that interest payments were initially required on Evan's student loans this year. Evan's AGI Taxable income
In early December Alice and Bob decided to open Sample Cafe with $15,000 of their own money and $20,000 borrowed from a friend. They have spent $13,000 on equipment and furniture, and they have purchased $3,100 worth of cups for cash which they expect will be used over the next three months. Having put down a $2,300 deposit for a location on Main St., they will pay the first month’s rent when they open their doors on January 1. In the balance sheet template below, fill in the appropriate values as of December 31.
Madeline Rollins is trying to decide whether she can afford a loan she needs in order to go to chiropractic school. Right now Madeline is living at home and works in a shoe store, earning a gross income of $960 per month. Her employer deducts a total of $170 for taxes from her monthly pay. Madeline also pays $115 on several credit card debts each month. The loan she needs for chiropractic school will cost an additional $170 per month. Calculate her debt payments-to-income ratio with and without the college loan. (Remember the 20 percent rule.) (Enter your answers as a percent rounded to 2 decimal places.) With college loan Without college loan Debt Payments-to- Income Ratio
Mayesha purchased a large screen TV for $4,000 and can pay it off in ten months with an add-on interest loan at an annual rate of 11.5%, or she can use her credit card that has an annual rate of 18%. If she uses her credit card, she will pay $400 per month (starting next month) plus the finance charges for the month. Assume that her credit card company uses the unpaid balance method to compute her finance charges and that she is making no other transactions on her credit card. Which option will have the smaller total finance charges on her loan? What is the general method that should be used to solve this problem? A. Use the formula l= Prt to find the finance charge for both the add-on and the credit card option. Choose the option that produces the lower number. O B. Multiply the cost of the TV set by the annual rate to find the finance charge for both the add-on and the credit card option. Choose the option that produces the higher number. O C. Use the formula l= Prt to find the…
Like many college students, Diana applied for and got a credit card that has an annual percentage rate (APR) of 15%. The first thing she did was buy a new DVD player for $400. At the end of the month, her credit card statement said she only needed to make a minimum monthly payment of $15. Assume Diana makes her payment when she sees her statement at the end of each month. If Diana doesn't charge anything else and only makes the minimum monthly payments, approximately how many months would it take her to completely pay off the DVD player? Assume that the credit card company compounds interest at the end of each month. O 35.8 months O 37.8 months O 46.3 months O 50.0 months O 32.6 months Diana now realizes she needs to pay more than just the minimum payment (unless she wants to be paying for this DVD player until she graduates). She decides to pay twice the minimum monthly payment ($30 per month), instead. How much quicker will she pay off the DVD player? 19.5 months O 26.4 months O 21.1…
Ernie Bilko has a business idea. He wants to rent an abandoned gas station for just the months of November and December. He will convert the gas station into a drive-through Christmas wrapping station. Customers will drive in, drop off their gifts, return the next day, and pick up their wrapped gifts. He needs $331,700 to rent the gas station, purchase wrapping paper, hire workers, and advertise. If he borrows this amount at 6.5 interest for those two months, what size lump sum payment will he have to make to pay off the loan? (Round your answer to the nearest cent.) $ _______
Your friend has asked you for budgeting help. They have a combined net family income of $138,000 per year. They have no children. They live in a three-bedroom house. Their expenses are as follows: Yearly payments: Taxes: $1,200 Insurance: $3,300 Car Expenses: $1,950 Monthly payments: Utilities: $350 Phone/Internet/TV: $180 Food: $700 Clothing: $250 Office supplies: $160 Car payments: $740 Weekly payments: Mortgage: $540 Entertainment: $120 4 This year, they would like to contribute a total of $24,000 to their RRSP. Determine whether they can afford that contribution. If so, how much (if any) do they have left for savings? Include your calculations and give a word answer.
In early December Alice and Bob decided to open Sample Cafe with $16,000 of their ownmoney and $20,000 borrowed from a friend. They have spent $13,000 on equipment andfurniture, and they have purchased $3,200 worth of cups for cash which they expect will beused over the next three months. Having put down a $2,300 deposit for a location on MainSt., they will pay the first month’s rent when they open their doors on January 1.In the balance sheet template below, fill in the appropriate values as of December 31.
Ed and Marta are paid $2 comma 410 after taxes every month. Monthly expenses include $777 on housing and utilities, $395 for auto loans, $164 on food, and an average of $713 on clothing and other variable expenses. Assuming that they save excess funds, calculate and interpret their savings ratio. Hint: Prepare an income statement, and then compute the ratio.

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS