Question: Please show work in Excel. You are considering a loan for an upcoming purchase (car, house, etc.). You will need $1,632.08 for this purchase. The

Please show work in Excel. You are considering a loan for

Please show work in Excel.

You are considering a loan for an upcoming purchase (car, house, etc.). You will need $1,632.08 for this purchase. The bank will lend to you at 15.21% annual interest (APR). The bank expects you to make a payment every year, for 35 years. If all the payments must be the same, what will be the per period payment needed to pay off the loan on time? Answer =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You are considering a loan for an upcoming purchase (car, house, etc.). You will need $5,208,840.56 for this purchase. The bank will lend to you at 3.18% annual interest (APR). The bank expects you...

Please show work in excel!! Milestone #3 - Car - Lease vs. Purchase Due: Friday, October 22 by 11:59pm into dropbox You are finishing up your first year of work in the real world. Budgeting is...

26. Evaluate the expression for the given value of the variable. (2 pts.) 3x2 + 36. 42. 10. x=2 y=5 (2 pts.) Problems 20, 42, 50, 66, 68 Combine like terms. (2 pts.) Solve the equation. (2 pts.) x1 5...

Hello, I am needing help with these questions. The correct answers are the numbers in blue, just getting confused on which formulas need to be inputted. Please show the work on how you got these...

20,000$ dollar house show work please 20,000$ house please show work Assume that you will finance 70% of the asking price of the home. Visit the Bank Of HFC Interest Rate Claim Site (Also known as...

**Please show caculations on excel spreadsheet! You have an opportunity to purchase the 23 site Plum Creek manufactured home/RV park for $250,000. The park caters to extended stay residents (six...

please show work 4.1 Compound Interest 1. Find the simple interest on a $500 investment made for 2 years at an interest rate of 8%/year. What is the accumulated amount? 2. A bank deposit paying...

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company...

I need chapters 18, 19, 20, and 21 for the workbook for Personal Finance by Madura!! Please help!!! Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX...

A,B,C enter into a partnership investing Rs 6,000 and Rs. 7,000 and Rs. 8,000 respectively. They invested this amount for 8 months, 6 months and 4 months. The share of 8 in an annual profit of Rs....

Hector Garcia, a bilingual Mexican-American, is a salesperson for Gloor Lumber and Supply, Inc. Management complimented Garcias work on several occasions and gave him a $250 bonus at the end of his...

Total stock return is equal to: * 1 point capital gain + price change. dividend yield + income. dividend yield + price change

Question 6 Not yet answered Which among what is given below result to a negative correlation? (2 pts ) Marked out of 2.00 O a. P Flag question No of visitors in the beach and the weather O b....

1. To gain insight into why we believe more in one type of information than another.

2. In this chapter, the reader should reflect on the following concepts: emo-tional information, concrete information, local information, the reference object, consensus information, conflict...

11. Give two examples of each of the following heuristic assessment mechanisms. a) We use the information that is currently accessible. b) We assume an initial anchor point (value). c) We compare to...