You are applying | Business & Finance homework help


Use excel format. Make separate tabs for 6.B, 6.A, 5.A

Solutions should be in an Excel file, using specific finance formulas such as =FV(……), =PV(……), =PMT(…), =RATE(…), =NPER(…), etc.



1.         You are applying for a 30-year, fixed-rate (APR 6.50%),monthly-payment-required mortgage loan for a house that sells for $80,000 today.  The mortgage bank will ask you for 20% initial down payment of the house value, and charge you an extra $3,000 closing cost (carried into loan balance and amortized later) when the loan is approved. 


(a) What should be your monthly loan payment (assuming payment is due by the end of each month)? 


(b) 10 years after buying the house, what will be the remaining principal balance of your loan?  (Hint:  For a loan or investment, the beginning balance is the same as “present value”, whereas the ending or remaining balance is the same as “future value”.  And please don’t forget this is a monthly loan.)


(c) 10 years after buying the house(as Part b aforementioned), the loan market rate drops from 6.50% APR to 4.50% APR, you want to refinance on the remaining loan principal balance, but the bank will charge you an extra $4,000 refinancing fee (carried into loan balance and amortized later).  Would you be able, and by how much, to lower your monthly loan payment if you choose to refinance over the remaining loan life (i.e., instead of the extension of another 30 years)?  Based on your calculation results, should you choose to refinance or not?




2.         By the end of each year, you contribute a $3,000 to your retirement fund portfolio, which on average earns an annual return of 12.5% in the financial marketSuch annual contributions continue until your retirement.


(a) 30 years later you retire, how much money do you have in your portfolio by then?         


(b) For your post-retirement life (which last approximately another 20 years), every year you withdraw and spend an equal amount of annuity payment from your fund account.  What would be the annual payment amount you spend if you do not want to leave any money to your heirs? (Hint: Even after you retire, will the financial market and your fund account retire then?  That is, what will be the applicable interest rate or money growth rate for your post-retirement years?)


(c) Considering the long-term inflation rate amounts to 3.5% annually, how much money at real purchasing power will you actually have when you retire?  How much should you withdraw and spend per year at real purchasing power for your post-retirement life?  (Hint: Your stated “annual return of 12.5%” is just nominal in this case; just as your boss gives you an annual salary raise of 3%, but how much real-purchasing-power “raise” you are getting per year actually, considering the annual inflation factor?)



7.         If you deposit $4,000 at the end of each of the next 20 years into an account paying 11.2 percent interest, how much money will you have in the account in 20 years? How much will you have if you make deposits for 40 years?

8.         You want to have $90,000 in your savings account 10 years from now, and you’re prepared to make equal annual deposits into the account at the end of each year. If the account pays 6.8 percent interest, what amount must you deposit each year?

9.         Dinero Bank offers you a $50,000, seven-year term loan at 7.5 percent annual interest. What will your annual loan payment be?

10.       The Maybe Pay Life Insurance Co. is trying to sell you an investment policy that will pay you and your heirs $25,000 per year forever. If the recquired return on this investment is 7.2 percent, how much will you pay for the policy?



6.         Assume the total cost of a college education will be $290,000 when your child enter college in 18 years. You presently have $55,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education?

7.         At 7 percent interest, how long does it take to double your money? To quadruple it?

9.         You’re trying to save to buy a new $170,000 Ferrari. You have $40,000 today that can be invested at your bank. The bank pays 5.3 percent annual interest on its accounts. How long will it be before you have enough to buy the car?

11.       You have just received notification that you have won the $1 million first prize in the centennial liberty. However, the prize will be awarded on your 100th Birthday (assuming you’re around to collect). 80 years from now. What is the present value of your windfall if the appropriate discount rate is 10 percent?

18.       You have just made your first $4,000 contribution to your retirement account. Assuming you earn an 11 percent rate of return and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing?


Custom Writings Help
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.


Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.


Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.


Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.