Pls help and show all work and explain everything thoroughly pls. Pls do all questions. Pls pls. Pls look at both images as the second image has the questions. Pls pls pls pls do this question. b) What percent of Anika's costs are fixed? Why is this important?c) Identify three (3) additional expenses that you think Anika has forgotten to include? Explain why it isimportant. Estimate the monthly amount for any missing expenses.d) Can Sophie and Daniel save $10 000 in one year (not including the 3 additional expenses)? Explain. 1. Sophie and Daniel have a net income of $70 000 a year. This table shows their expenses.ExpenseStudent loan paymentsAmount$225/every 2 weeks$1215/monthRentElectricityGas$100/month$125 every 2 months$180 every 3 months$150/week$69/monthWater & SewageFoodFamily cell phone planClothingCar lease (including maintenance)$80/every 2 weeks$275/monthCar Maintenance$30/monthGasoline$65 every 2 weeks on average$175/monthCar InsuranceMiscellaneous$50/every 2 weeksa) Use the data provided to design a MONTHLY budget for Sophie and Daniel.Show your calculations and indicate whether each expense or income is FIXED or VARIABLE.Monthly Amount ($)Fixed ($)IncomeTotal (S)Net incomeTotal IncomeFixed ($)Variable ($)ЕxpensesStudent loan paymentsRentElectricityGasWater & SewageFoodFamily cell phone plan|ClothingCar lease (includingmaintenance)Car MaintenanceGasolineCar InsuranceMiscellaneousTotal ExpensesTotal Income - Total Expenses

Yearly income is $70,000 so the per month income will be 70,000/12 = $5,833.34 Student Loan Payments…

Answered: Pls help and show all work and explain…

Pls help and show all work and explain everything thoroughly pls. Pls do all questions. Pls pls. Pls look at both images as the second image has the questions. Pls pls pls pls do this question.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 28P

See similar textbooks

Similar questions

Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $758.48. Performance Task You need to present Jim and Joan with a report detailing the following: A recursive formula for their balance after each monthly payment has been made. A determination of Jim and Joan's balance after the first payment. Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment. Determine when the balance will be below $75,000. Determine when the balance will be paid off. Determine the interest expense when the loan is paid.
1. Caroline is a single parent. Her annual net income is $42 000. She has $25 000 in savings. Caroline spends $125/week on food, $400/month on transportation, $120/month on clothing, $75/2 weeks on entertainment, and $200/ month on miscellaneous expenses. Option 1: Buying a 3-bedroom townhouse Down payment of $18 000 Bi-weekly mortgage payments of $640 Monthly maintenance fees of $250 Option 2: Renting a 3-bedroom townhouse $1025 per month, plus utilities Which housing option would you recommend to Caroline? Justify your answer.
Franki finances a motor home for $44,700 by taking out an installment loan for 36 months. The payments were $1,774.31 per month and the total finance charge was $19,175.16. After 25 months, Franki decided to pay off the loan. After calculating the finance charge rebate, find the loan payoff amount.
Frankie finances a motor home for $44,300 by taking out an installment loan for 36 months. The payments were $1,784.31 per month and the total finance charge was $19,935.16 after 21 months Frankie decided to pay off the loan. After calculating the finance charge rebate, find the loan payoff amount. $22490.17 $23,897.36 $22,417.77 $23,172.73
Jack and Jill purchase a house and finance $375,000 at 2.8% for 30 years. Their annual insurance is $1,225 and their annual property tax is $5212. How much is their PITI payment each month? Remember, that amount includes principal, interest, property taxes and insurance. You must show the formulas with the values filled in.
Jill wants to buy a home. Her monthly gross income (GI) is $7,000. She currently has a car payment of $480/month. The bank wants her to escrow $450/month for taxes (T) and insurance (HI). The bank requires the following income and loan ratios; a minimum down payment of 20%, a P&I as a percent of GI ratio < 25%, a P, I, T, & HI as a percent of GI ratio < 28%, a P, I, T, HI and other debt service as a percent of GI ratio < 36%, and a LTV ratio of 80% or less. What is the maximum market value of a home that Jill could purchase given a current market rate on a 30-year fixed rate loan is 4.75%?
Bob purchases a car for $28,000. He makes $640 a month payments for 36 months on a 6.9% interest loan. What is his balloon payment?
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly payment is determined to be $758.48. A recursive formula for their balance after each monthly payment has been made. A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment create a table showing their balance after each monthly payment. Determine when the balance will be below $75,000. Determine when the balance will be paid off. Determine the interest expense when the loan is paid.(find the total paid, and subtract 120,000 from it).
Pete Frank bought a computer for $4,000. Pete put down $500 and financed the balance at 10 ½% for 36 months. What is his monthly payment? (Use loan amortization table.)
Cathy borrowed $24,000 to buy a new car and expects to pay $400 per month for the next 3 years to pay off the loan. What is the loan's annual rate of interest? m Nper (or N) =n*m Rate (or I/Y)=i/m PV PMT FV Identify variables and use excel
Theresa borrowed $7258.00 compounded monthly to help finance her education. She contracted to repay the loan in monthly payments of $265.00 each. If the payments are due at the end of each month and interest is 4% coumpunded monthly, how long will Theresa have to make monthly payments? State your answer in years and months (from 0 to 11 months). theresa will have to make payments for _____ year(s) and ______ month(s)
Mr. and Mrs. Smith have just purchased a $600,000 house and have made a down payment of$120,000. They can amortize the balance at 4% for 30 years. Using Excel, populate the following amortization table: payment number 1, 60,180,240,300,360 monthly payment principle interest amount paid on loan