Question Read and analyze each given scenario and provide what is asked. Show your complete solutions. 1. It is now January 1, 20x8. Today you will deposit P100,000 into a savings account that pays 8%. a. If the bank compounds interest annually, how much will you have in your account on January 1, 20x9? b. What will your January 1, 20x9 balance be if the bank uses quarterly compounding? 2. It is now January 1, 2x16, and you will need P100,000 on January 1, 2x20. Your bank compounds interest at an 8% annual rate. How much must you deposit today to have a balance of P100,000 on January 1, 2x20? 3. If you deposited P200,000 in a bank account that pays 6% interest annually, how much will be in your account after five (5) years? 4. What is the present value of a security that will pay P290,000 in 20 years if securities of equal risk pay 5% annually? 5. What is the future value of a 5%, 5-year ordinary annuity that pays P8,000 each year? If this was an annuity due, what would be its future value?

Q: After selling a bunch of old "junk" on e-bay, you have $500. You deposit the money into an account…

A: The annual percentage rate incorporates all the fees, charges, interest, rewards, and payments that…

Q: plete your last year in business school and then go through law school, you will need $10,000 per…

A: The present value of the money needed today is the required money to sustain the four year…

Q: Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000…

A: Annual return on investment is 41.42%. Computation of annual return on investment: Excel spread…

Q: I now have $12,000 in the bank earning interest of 0.50% per month. I need $22,000 to make a down…

A:

Q: Solve each of the following questions using both pricing formulas and Excel.  1. If you wish to…

A: Present value refers to the current value of money which is required to put for a certain amount in…

Q: Suppose you open a credit card account and charge $125 to the account on the first of each month to…

A: Fill in the given table: Formulas for the above table:

Q: . Suppose you have a bank account into which you make $100 deposits each month. You find a bank…

A: Periodic Payment = $100 Future Value = $2,000 Time Period = 15 Months

Q: It is now January 1, 20x8. Today you will deposit P100,000 into a savings account that pays 8%. a.…

A: Present value of deposited amount (PV)= P100,000 Interest rate (r)= 8% Compounding frequency=…

Q: 4. Consider a credit card with a balance of $7000. You wish to pay off the credit card, which has an…

A: a.Calculate the maturity period to repay the debt as follows:MS-Excel --> Formulas -->…

Q: I now have $28,000 in the bank earning interest of 1.00% per month. I need $38,000 to make a down…

A: given information  interest rate per month = 1% present value = $28,000 future value = $40,000…

Q: Hamad is saving to establish a small business. He deposits a fixed amount of money every month in a…

A: Annuity refers to series of equalized payments that are made either at start or end of specific…

Q: On Monday morning, you have $5000 in cash on hand. For the next seven days, the following cash…

A:

Q: Determine the value of n and t in each problem below. In the coming three years, you will need Php…

A: solution Given for first question Future value needed 200000 Present value ?…

Q: 7

A: Loan is referred as the form of the debt, which are incurred through an individual or another…

Q: You are shopping around to determine which bank account yields the highest return. You have three…

A: Amount = $2,200 Time Period = 2 Years

Q: Chapter 7 Self Test Problem #1

A: Formula:

Q: You put $250 in the bank for 5 years at 12% a. if interest is added at the end of the year, how…

A: Req-1         Beginning Balance Interest Amount Ending Balance   (A) (B* 12%) (C) = (A+B) Year…

Q: • • If you are saving money in a bank, which of the following is better for you? Bank A, which…

A: Time value of money (TVM) refers to the method or technique which is used to measure the amount of…

Q: Sandra Alcocer goes to her bank to ask for your help to get her out of her current predicament. She…

A: Here, Note: Here, two years to complete is considered as amount deposited after 2 years.

Q: You want to be able to withdraw $4000 from an account at the end of each year for the next 19 years.…

A: In the given question we require to calculate the amount of money to be invest today to receive…

Q: Ray Miller was looking for funds to support his company's expansion. His bank offered him a $25,000…

A: Value of simple discount loan is $25,000 Interest rate is 10% Time period is 90days To Use: 30/360…

Q: You want to be able to withdraw $5000 from an account at the end of each year for the next 12 years.…

A: Information Provided: Payment = $5000 Term = 12 years Interest rate = 5.5% compounded annually

Q: You want to be able to withdraw $50,000 each year for 15 years. Your account earns 7% interest. a)…

A: Here, Annual Withdrawals (PMT) is $50,000 Time Duration is 15 years Interest Rate is 7%

Q: Answer the questions below and show all working from a financial calculator. Do not use excel: 1.…

A: The question is based on the concept of  Annuity

Q: A woman opens an account with $6000 and then adds $2500 at the end of each 6-month period for 6…

A: The present value function or concept can be used to determine the present value of a future sum or…

Q: How much money should you put in the bank now to have the bank pay 100 JD each month starting the…

A: The perpetuity refers to the series of payments and receipts that last for an infinite period of…

Q: Use this information for questions 9 to 12: You are put in charge of starting a credit card business…

A: “Since you have posted multiple questions, we will solve the first question for you. To get the…

Q: You are planning on enrolling in the Master of Finance in 4 years time and will be required to pay…

A: We need to calculate present value of fees to be paid at enrolment. the $45,000 fees is the future…

Q: You need a quick loan and decide to use the local "payday" loan office. The loan is for $800 and you…

A: FV = PV*(1+r)^n, Where, Given that Loan obtained (PV) = $ 800 Loan amount paid (FV) = $ 1025…

Q: You have $4,500 on a credit card that charges a 21% interest rate. If you want to pay 8! 4 years,…

A: In this question one has to find the payment that needs to be paid to the credit card company each…

Q: Jim Hayes wants to buy some electronic equipment for $800. Jim has decided to save uniformamount at…

A: Electric Equipment cost = $800 Months(n) =12 Interest Rate(r) =0.50% Let Monthly Payment is P

Q: You want to be able to withdraw $4500 from an account at the end of each 6-month period (that is,…

A: Using Excel PV function

Q: Jane wants to buy a house and approaches the bank to borrow $638,000. The bank agrees to lend her…

A: A loan refers to a sum of the amount that is being borrowed by a borrower who is in need of funds…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much…

A: Discounting is a technique through which present value (PV) of future cashflows is computed by using…

Q: Ray Miller was looking for funds to support his company's expansion. His bank offered him a $25,000…

A: Discount note is one of the ways to raise the funds in the form of short term borrowings. Borrower…

Q: Starting next year, you will need $5,000 annually for 4years to complete your education. (One year…

A: The present value of the annuity is the current worth of a cash flow series at a certain rate of…

Q: solve the following showing all workings in microsoft word   It is now January 1, 2018 you plan to…

A: Future value annuity due is a method used to calculate the total amount at the end of a period when…

Q: Nana Seinfeld (Jerry’s grandma) invested $1500 at an interest rate of 1.25% compounded annually at…

A: Present value of money refers to the value of money today which is expected to receive or gain in…

Q: Starting next year, you will need Php120,000 annually for three years to complete your education.…

A: The amount of deposit can be find out by using the formula of present value of ordinary annuity.

Q: You have $20,000 that you put on deposit on your 30th birthday at 5% compounded annually. On your…

A: The future value of a cash flow is the future worth of a cash flow at a certain rate of interest and…

Q: You deposit $175,000 in a savings account. The APR (Annual Percentage Rate) is 6%. Calculate the…

A: Initial deposit = $175,000 Annual percentage rate = 6% Time = 10 years So, Future value =Initial…

Q: You deposit $200 each month into an account earning 2% interest compounded monthly. Round to the…

A: Using Excel

Q: Suppose that your weekly cash expenses are $80. Every time you withdraw money from the automated…

A: The practice of collecting and managing cash flows is known as cash management. Individuals and…

Q: Suppose you deposit $3600 to open an account that earns 6% interest compounded monthly. You are…

A: Present value is the sum of money that must be invested in order to achieve a specific future goal.…

Q: How much should you invest now to have enough for your purchase?

A: Time value of money (TVM) means that the amount of money received in the present period will have…