Use the following information for the next two questions:
Please answer the two questions. Thank you <3
You finished your studies, passed the CPA board exams, and now an accountant. A real estate company offered to sell you a house with a cash selling price of P14,000,000 under an in-house financing agreement. The amortization will be on a monthly basis over a period of 25 years and the effective interest rate is 12%. You are wondering if you can afford to purchase the house. You estimated your monthly expenditure to be P36,600, which included a risk adjustment allowance.
7. What should be the minimum balance of your monthly take home salary so that you will be able to afford to purchase the house?
a 147,451.38
b. 148,051.38
c. 151,048.38
d. 184,051.38
8. How much is the total interest expense on the financing agreement ?
a. 30,235,414
b. 23,335,216
c. 20,235,414
d. 13,265,992
Step by stepSolved in 2 steps with 1 images
- An insurance agent just offered you a new insurance product that will provide you with $1,959.20 13 years from now if you invest $400 today. What annual rate of interest would you earn if you invested in this product?arrow_forwardYou decide to do some remodeling in the kitchen. Your parents agree to lend you the money, but you insist on paying them interest. The agreement is that they will lend you $6000.00 at a simple interest rate of 1.5% per year. In how many months will the interest be $360.arrow_forwardAnswer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $arrow_forward
- show all excel formulas/ work answering the following: Saving For Retirement You are offered the opportunity to put some money away for retirement. You will receive five annual payments of $25,000 each beginning in 40 years. How much would you be willing to invest today if you desire an interest rate of 12%?arrow_forwardThe Potters want to buy a small cottage costing $120,000 with annual insurance and taxes of $740 and $2200, respectively. They have saved $15,000 for a down payment, and they can get a 6%, 25-year mortgage from a bank. They are qualified for a home loan as long as the total monthly payment does not exceed $1000. Are they qualified? Click the icon to view the Real Estate Amortization Table Select the correct choice below and fill in the answer box to complete your choice. (Round to the nearest cent as needed.) OA. No, because the total monthly payment is $ OB. Yes, because the total monthly payment is $ Submit test 0 ma on mo CHE Op ADD Quesarrow_forwardA. Solve the following problems and show your complete solution. 1. Anna bought a diamond necklace worth P185,000. Securing 15% down payment, they agreed to pay the remaining for 1 year with 12% annual interest rate. a. How much is the down payment? b. How much is the mortgage loan? 00 c. How much is the monthly amortization? d. Create an amortization table. HRISTIAarrow_forward
- I need the answer of the question attached. Please provide all possible answers. Thank you!arrow_forwardYou recently graduated and received a S5, 000 gift from your parents. Additionally, you secured a job with a monthly paycheck of S4, 000 after deductions. You decide to invest the gift and 10% of your monthly paycheck into an ETF that you expect to grow at a rate of 0.7% per month. What will be the balance of your investment account after 10 years assuming that your paycheck amount remains the same over these 10 years? Group of answer choicesS76, 392S86, 382S92, 133S87, 314arrow_forwardYou purchase a plot of land worth $54,000 to create a community garden. To do so, you secure a 10-year loan, charging 5.22% APR, compounded monthly, and requiring monthly payments of $505. (Assume the value of the land is still $54,000. Round each answer to the nearest dollar.) (a) Assuming that you put some money down, what was your original loan amount (in dollars)? X $ (b) What is the outstanding balance (in dollars) on your loan after making 4 years of payments? $ 170255.84 (c) How much equity (in dollars) do you have in the garden after 4 years? $ Xarrow_forward
- Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excelarrow_forwardAS an accountant at City Bank in Boston, Ken, the Loan Officer called you for some help on a loan application that he is working on. One of his customers is looking for a $50,000 loan for a car. He is offering him a 7% 5 year $50,000 loan and asking you to help him calculate the installment amount. This is the data Ken sent you: Face Amount of Loan $50,000 Contract Rate… 7% Term of the Loan….. 5 yearsarrow_forwardAfter graduation, you just got hired by an engineering company and you were planning to take aloan in order to purchase a new car. Let’s assume that the bank is willing to offer you a personalloan with an annual interest rate of 6% compounded yearly. The car price is 26,500 JD and youare capable to pay 4,200 JD per year. After how many years you will be able to pay back the loanwith the accumulated interest (use a spreadsheet to answer this question) and draw the cash flowdiagram.arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education