You are considering the purchase of a house. The morigage company is approving 15-year loans at 4.5%. Use the Present Value Excel Template to determine what amount you could borrow based upon a budget with estimated monthly house payments of S1,500? Enter as a positive number with two decimal places (e., to the penny) but without the dollar sign here:

You are considering the purchase of a house. The morigage company is approving 15-year loans at 4.5%. Use the Present Value Excel Template to determine what amount you could borrow based upon a budget with estimated monthly house payments of S1,500? Enter as a positive number with two decimal places (e., to the penny) but without the dollar sign here:

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

You need a quick loan and decide to use the local "payday" loan office. The loan is for $800 and you pay it back 13 days later. You end up paying them back $1025. Assume the company compounds interst on a DAILY basis.. la. What is the effective interst rate per year? 1b. What would you owe if you kept the money for 1 year? please show work on excel
You would like to put some money into an account so that you will have $6000 in the account 13 years from now. If the account earns 3.5% interest per year, compounded quarterly, how much should you invest now in order to reach your goal? Give the answer correctly to 2 decimal places. dollars Do NOT use the dollar sign in the answer box. ns
You are saving for a new house. You place $55,000 into an investment account each year for five years. How much will you have after five years if the account earns (a) 3%, (b) 5%, or (c) 7% compounded annually? Note: Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places. (FV of $1, PV of $1, FVA of $1, and PVA of $1) a. b. C. Annuity Payment $ 55,000 55,000 55,000 > Answer is complete but not entirely correct. Annual Rate 3% 5% 7% Interest Compounded Annually Annually Annually Period Invested 5 years 5 years 5 years Future Value of Annuity $ 63,760.07 X 70,195.49 X 77,140.35 x
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?
Please answer it in a comprehensive and detail manner with step by step algorithm. No excel's sheet solution.
You are saving for a new car. You place $14,200 into an investment account today. How much will you have after four years if the account earns (a) 4%, (b) 6%, or (c) 8% compounded annually? Note: Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places. (FV of $1, PV of $1, FVA of $1, and PVA of $1)
what would the formula be to solve for the table value? the table value is what i need to solve the problem
You want to buy a new sports coupe for $87,500, and the finance office at the dealership has quoted you an APR of 6.9 percent for a 48-month loan to buy the car. a. What will your monthly payments be? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the effective annual rate on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Monthly payment b. Effective annual rate %
Compute the monthly payment and the total amount spent for a vehicle that costs $24,000 if you finance the entire purchase over 5 years at an annual rate of 8 25 percent. Calculate the payment if you finance the car for only four years. Finally, calculate the payment for three years. What do you notice about the payment under the different time assumptions? Note: Round intermediate computations to at least five (5) decimal places Click on the table icon to view the MILPF table The monthly payment, PMT, on the 5-year auto loan is $ (Round to the nearest cent.) The total amount spent if you financed $24,000 for 5 years at 8 25 percent per year is $ (Round to the nearest cent.) The monthly payment, PMT, on the 4-year auto loan is $ (Round to the nearest cent.) Finally, the monthly payment, PMT, on the 3-year auto loan is $ (Round to the nearest cent.) What do you notice about the payment under the different time assumptions? (Select the best choice below.) OA. As the number of payments…
Please show working and answer a and b 1. You have saved $4,000 for a down payment on a new car. The largest monthly payment you can afford is $500. The loan will have an 8% APR based on end-of-month payments. (A) What is the most expensive car you can afford if you finance it for 48 months? Do not round intermediate calculations. Round your answer to the nearest cent.$ What is the most expensive car you can afford if you finance it for 60 months? Do not round intermediate calculations. Round your answer to the nearest cent.$
You want to buy a car, and the local bank will lend you $20,000. The loan will be fully amortized over 5 years (60 months) and the nominal interest rate will be 12%. The interest will be paid monthly. What will be the monthly loan payment? draw a time line and identify the known variables and unknown variables as if you were to input in EXCEL.
Help me with step by step answers on a TI 83, TVM solver and forumulas and timelines. You want to buy a car and need to see how big of a car loan you can afford. Your budget allows you allocate $289.99 per month for car loan payments. The bank will offer you a loan at 6% interest on an APR basis and monthly payments over five years. What is the amount of the loan you can afford? Use the $ symbol and round to the nearest dollar (no decimal places). Use commas in your answer if applicable.