Answered: How much downpayment should you put at…

Business

Finance

How much downpayment should you put at the time of purchase? how would i calculate this in excel?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter5: Making Automobile And Housing Decisions

Section: Chapter Questions

Problem 8FPE

See similar textbooks

Related questions

Q: Consider two lotteries. Lottery A is such that an individual receives a prize of 1.25 units of a con...

A: The expected value is determined by multiplying the probability with its units. This is expected val...

Q: How much would a business have to invest in a high-growth fund to receive $13,000 every month for 7 ...

A: First we need to calculate present value of all withdrawals by using the following formula PV...

Q: Current market price of ABC stock is $77 ABC Stock price after 30 days =$80 ABC Stock price after 45...

A: A) Price or face value of call option as on today = MAXIMUM,{0, CURRENT MARKET PRICE(CPM)-EXCISE ...

Q: Sixty monthly deposits are made into an account paying 8% nominal interest compounded monthly. If th...

A: We need to use future value of ordinary annuity formula to calculate monthly payment PMT =FVn(1+r)n ...

Q: A contract has been signed to lease a building at P21.483 per year with an annual increase of P1,045...

A: Given: Lease = P21,483 Annual increase = P1,045 Years = 10 Interest rate (Rate)= 8.78%

Q: You are a loan officer of Third National Bank and already way behind your target revenue for the yea...

A: Banks gives loan to the business so that they can grow the business and bank also get the business a...

Q: Devin started a fund that would pay out $1,400.00 every month in perpetuity. The fund earns 3.72% co...

A: Perpetuity Perpetuity is the series of fixed payments which is incurred or received for the infinite...

Q: ract requires lease payments of $900 at the beginning of every month for 3 years. a. What is the pre...

A: The present value of annuity is the value of annuity without interest and that is the value today.

Q: Find the present value of the following ordinary deferred annuity. Periodic Made Payment Period Peri...

A: First, we will compute the annual effective rate based on quoted rate and quarterly compounding. The...

Q: What is the micro-stop store's gross profit, if the total sales is P125,750.00 and the cost of sales...

A: Total sales = P125,750.00 Cost of sales ratio = 42.25%

Q: Suppose that standard deviation of monthly changes in spot prices of live cattle is 1.2 cents per po...

Q: How much should Ryan have in a savings account that is earning 2.50% compounded monthly, if he plans...

A: Present Value of Annuity: It represents the present worth of the future cash flows stream and is co...

Q: Tom has decided to invest $400 quarterly for 4 years in an ordinary annuity a 8%. As his financial a...

A: Quaterly investment amount is $400 Time period is 4 years Interest rate is 8% To Find: Cash value o...

Q: Lou Lewis, the president of Lewisville Company, has asked you to give him an analysis of the best us...

A: Evaluating alternatives: When a company is faced with the choice of two alternatives, both alternati...

Q: Identify whether each of the following is an example of adverse selection or moral hazard. A. Joe be...

A: A phenomena where there is asymmetric information between the parties involved in a transaction are...

Q: Redan, Inc., is expected to maintain a constant 5.4 percent growth rate in its dividends, indefinite...

Q: At an interest rate of 10% per year, the perpetual equivalent annual cost of $70,000 now, $100,000 a...

A: Perpetual equivalent annual cost in simple words is an annual cost of one period considering the who...

Q: Nike Enterprises sells widgets for $10 a piece which cost them $6 to make. In a good year (probabili...

A: Since question involves multiple subparts , we will answer 1st sub 3 parts for you as per prescribed...

Q: Steph creates a ratio spread by buying four 100-strike put options and selling one 110-strike put op...

A: A put option (or "put") is a contract that grants the option buyer the right, but not the obligation...

Q: Firm Z has issued 1,000,000 bonds. Each bond is priced at $929 and has a face value of $1000. It pay...

A: Price of bond = 929 Face Value = 1000 Annual Coupon = Coupon Rate * Face Value = 3%*1000 = 30 N = 20...

Q: What is the impact of deferred annuities in consideration to business matter?

A: The legal contract between any entity and an insurance company is a deferred annuity contract. The i...

Q: The SUTA rate for Thomson Temp Agency is 5.4% and it’s FUTA rate is 6% less the 5.4% SUTA credit. If...

A: The following is the Calculation of total FUTA and SUTA taxes: SUTA tax = $378FUTA t...

Q: What is the compound amount and interest if Php 10,000 is invested at 3.6% compounded monthly for 2 ...

A: we know that, A=P(1+rn)n×t now, A= amount after time + (future value) P= principal amount (initial v...

Q: A Forward Rate Agreement contains an agreed interest rate of 5.75% on a 6-month loan. If settled at ...

A: Forward rate agreements are used by entities to hedge against interest rate risk. It is an over the ...

Q: Situation: Your friend came to you for advice whether or not to invest in a particular stock which p...

A: Given: Profit = $200,000 Probability of profit = 30% Loss = -50,000 Probability of loss = 70%

Q: What is the total interest paid to the nearest cent if the car costs $36,915, your down payment is $...

A: A credit score is a metric which shows the ability of a person or an organisation to repay its debt ...

Q: Firm Z has issued 1,000,000 bonds. Each bond is priced at $929 and has a face value of $1000. It pay...

A: Firm Z has different sources of capital - debt, equity and preferred stock. We will have to find the...

Q: Differentiate between the Passing of Risk and the Passing of Ownership.

A: when the goods are sold the risk remains with the seller until the property in the goods is transfer...

Q: Assume the $12,480 Treasury bill, 5% for 15 weeks. Calculate the effective rate of interest. (Use ca...

A: Effective rate of interest = Amount of interest / [ (Principal - Amount of interest) x Time period ...

Q: Pearson's books had total markdowns of $1,125 and a net markdown of $434 for the month of October. C...

A: Mark down is the reduction in price of an item below its original selling price. Markup cancellation...

Q: 4) Suppose you are a financial manager for the Shah Corporation and trying to decide between the fol...

Q: 3. Pielago is eyeing for another company to invest her excess funds. She is interested in a publicly...

A: Constant Growth Model: Under this model, it is assumed that dividends paid by the company go up at ...

Q: F G H Monthly Monthly Еxcess Excess return for Market Stock 1 Returns 0.09 0.03 -0.07 0.01 0.02 0.02...

A: Risk and return are two main components of investment. Beta a measure which shows the degree of risk...

Q: In four years of employment, John was able to save P250,000 after he had invested on purchasing a mo...

A: The stock market is a location where traders may purchase and sell equities,investors can invest in ...

Q: Are the following capital budgeting or financing decisions?

A: Capital budget involves evaluation and comparison of costs and benefits from a project. Capital budg...

Q: INFO ON STOCK Years 4 Beta 2.89 Divadends QUESTIONS D1 4.89 D2 4.76 REQUIRED RETURN ON EQUITY Foreca...

A: Given: Info on stock Year 4 beta 2.89 Dividends D1 4.89 D2 4.76 D3 3.98 D4 3.25...

Q: An asset is expected to pay a cash flow of $10 every 6 months in perpetuity with the first cash flow...

A: Future value (FV) is the worth of a present asset at a future date based on an estimated rate of gro...

Q: Condominiums usually require a monthly fee for various services. At $280 a month, how much would a h...

A: Monthly fee = $280 Period = 12 years = 12*12 = 144 months

Q: lolanda purchased a Treasury bond with a coupon rate of 2.62% and face value of $100. The maturity d...

A: Here, Purchase Date is 7/Feb/2018 Maturity Date is 15th/ April/2019 Time Period between two dates is...

Q: A fianncial security generates a cash flow of 2 million every five years forever with the first cash...

A: Perpetuity is an annuity with indefinite life. Security's price today will be the present value of p...

Q: As a Project Engineering had been tasked to make an analysis and to recommend to your company on the...

A: Concept ROI means return of income. It is one of performance measure used to evaluate efficiency on ...

Q: Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets a...

A: We need to use the following formulas for ratio Total debt ratio =Total liabilities/total assets Deb...

Q: Find the present value of the following ordinary deferred annuity. Periodic Made Payment Period Peri...

A: A deferred annuity: A series of finite, constant receipts/payments made at fixed intervals is known...

Q: (Using common-size financial statements) The S&H Construction Company expects to have total sales ne...

A: Pro-Forma Income Statement Sales $1,54,00,000 Cost of Goods Sold ($15400000 * 62%) $95,48,000 ...

Q: The following are the information on the assets and labilities of DARARI Corporation on December 31,...

A: Acid test ratio Acid test ratio is a measure of the liquidity position of a firm. It indicates the f...

Q: Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets a...

A: Solution:- Debt equity means the ratio of debt to the equity in the capital structure of the company...

Q: how much will this collection be worth when that time comes?

A: Future Value: It represents the future worth of the present sum of money and is computed by the pro...

Q: Chelsea FC has $15 million debt outstanding due next year and currently has $8 million cash. Chelsea...

A: Expected return if Ronaldo is hired by the clubs with weighted average revue under various scenarios...

Q: List the credit bureaus and list information that is contained in a person's credit report.

A: "Hi, Thanks for the Question, Since you asked multiple questions, we will answer first question for ...

Q: Consider 1-factor model and assume that the price of a certain fixed income security P(y) for y=9% 9...

A: To Find: DVO1 Duration Convexity

Question

You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000.

How much downpayment should you put at the time of purchase?

how would i calculate this in excel?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Del Hawley, owner of Hawleys Hardware, is negotiating with First City Bank for a 1-year loan of 50,000. First City has offered Hawley the alternatives listed here. Calculate the effective annual interest rate for each alternative. Which alternative has the lowest effective annual interest rate? a. A 12% annual rate on a simple interest loan, with no compensating balance required and interest due at the end of the year b. A 9% annual rate on a simple interest loan, with a 20% compensating balance required and interest due at the end of the year c. An 8.75% annual rate on a discounted loan, with a 15% compensating balance d. Interest figured as 8% of the 50,000 amount, payable at the end of the year, but with the loan amount repayable in monthly installments during the year
You want to invest $8,000 at an annual Interest rate of 8% that compounds annually for 12 years. Which table will help you determine the value of your account at the end of 12 years? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.