Question

In: Finance

1. Answer the following questions: A) On April 30, 2020, Connie borrowed P 185,000 at 10%...

1. Answer the following questions:

A) On April 30, 2020, Connie borrowed P 185,000 at 10% compounded monthly. The loan is to be paid out in 90 equal monthly payments with the first payment on May 31, 2020. What is the size of each monthly payment?

B) Cocoy wants to accumulate P 230,000 in 9.5 years. Equal deposits are made at the end of each quarter in an account that pays 15% compounded quarterly. What is the size of each deposit?

C) A man deposits P 5,200 at the end of each three months in an account paying 14% converted quarterly. In order to accumulate P105,000, how many regular deposits every quarter must he make, and what is the size of the concluding deposit, if one is needed?

Solutions

Expert Solution

Solution A
PV of annuity for making pthly payment
P = PMT x (((1-(1 + r) ^- n)) / i)
Where:
P = the present value of an annuity stream 185000
PMT = the dollar amount of each annuity payment P
r = the effective interest rate (also known as the discount rate) 10.47% (1+10%/12)^12)-1)
i=nominal Interest rate 10.00%
n = the number of periods in which payments will be made 7.5 90/12
PV of annuity= PMT x (((1-(1 + r) ^- n)) / i)
185000= PMT x (((1-(1 + 10.47%) ^- 7.5)) / 10%)
Annual payment= 185000/ (((1-(1 + 10.47%) ^- 7.5)) / 10%)
Annual payment=      35,160.20
Monthly payment=        2,930.02
Solution B
FV of annuity
P = PMT x ((((1 + r) ^ n) - 1) / i)
Where:
P = the future value of an annuity stream 230000
PMT = the dollar amount of each annuity payment To be computed
r = the effective interest rate (also known as the discount rate) 15.87% (1+15%/4)^4)-1)
i=nominal Interest rate 15.00%
n = the number of periods in which payments will be made 9.5
Future value of annuity= PMT x ((((1 + r) ^ n) - 1) / i)
230000= PMT x ((((1 + 15.87%) ^ 9.5) - 1) / 15%)
Annual deposit= 230000/((((1 + 15.87%) ^ 9.5) - 1) / 15%)
Annual deposit=      11,308.26
Quarterly deposit=        2,827.07
Solution C
FV of annuity
P = PMT x ((((1 + r) ^ n) - 1) / i)
Where:
P = the future value of an annuity stream 105000
PMT = the dollar amount of each annuity payment 20800 (5200*4)
r = the effective interest rate (also known as the discount rate) 14.75% (1+14%/4)^4)-1)
i=nominal Interest rate 14.00%
n = the number of periods in which payments will be made To be computed
Future value of annuity= PMT x ((((1 + r) ^ n) - 1) / i)
105000= 20800*((((1 + 14.75%) ^ T) - 1) / 14%)
105000/20800= (1.1475)^T) - 1) / 14%)
5.048076923 =(1.1475)^T) - 1) / 14%)
5.04807692307692*14% =(1.1475)^T) - 1
0.706730769 =(1.1475)^T) - 1
1+0.706730769230769 =1.1475^T
1.706730769 =1.1475^T
Log (1.70673076923077) T* log 1.1475
0.232165018092333= T* 0.0597613991717461
T= 0.232165018092333/0.0597613991717461
T=               3.88 years
T=             15.54 Quarters

Related Solutions

Questions 1) Locate the Healthy People 2020 Framework and answer the following questions. a) What is...
Questions 1) Locate the Healthy People 2020 Framework and answer the following questions. a) What is the vision of HP2020? b) What are the overarching goals? 2) Locate the about page. What original accomplishment is HP2020 based on? 3) Locate the data about page. What are the three data objectives? 4) Locate the Leading Health Indicators (LHIs). There are only 12. Select one of the LHIs. a) What LHI did you select? b) What are the Leading Health Indicators for...
Answer the following elasticity questions: E = ∆% Q / ∆% P 1. The following data...
Answer the following elasticity questions: E = ∆% Q / ∆% P 1. The following data is from the demand for chocolate cookies: Producer reduces the price of some cookies from 12 to 10 cents. Find out that the quantities sold increased from 210 to 250 units: a) Calculate the price elasticity of cookies. b) Present the graph; Indicate if it is Price Elasticity of Demand or Supply. c) if it is elastic, inelastic or unitary. d) If the price...
On April 1, 2020, Mendoza Company (a U.S.-based company) borrowed 514,000 euros for one year at...
On April 1, 2020, Mendoza Company (a U.S.-based company) borrowed 514,000 euros for one year at an interest rate of 5 percent per annum. Mendoza must make its first interest payment on the loan on October 1, 2020, and will make a second interest payment on March 31, 2021, when the loan is repaid. Mendoza prepares U.S. dollar financial statements and has a December 31 year-end. Prepare all journal entries related to this foreign currency borrowing assuming the following exchange...
On April 1, 2020, Mendoza Company (a U.S.-based company) borrowed 504,000 euros for one year at...
On April 1, 2020, Mendoza Company (a U.S.-based company) borrowed 504,000 euros for one year at an interest rate of 5 percent per annum. Mendoza must make its first interest payment on the loan on October 1, 2020, and will make a second interest payment on March 31, 2021, when the loan is repaid. Mendoza prepares U.S. dollar financial statements and has a December 31 year-end. Prepare all journal entries related to this foreign currency borrowing assuming the following exchange...
10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The...
10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The balance on the bank statement is $8,000. At the end of April, the balance per the books is $5,020. There are checks outstanding of $5,800 and a deposit in transit of $4,000. On the bank statement there is a EFT received of $1,500. There is an NSF check from Steve Mayberry for $300 and a bank service fee of $20. What is the reconciled...
Given the data set below, use it to answer the following questions: 10, 20, 30, 40,...
Given the data set below, use it to answer the following questions: 10, 20, 30, 40, 50 a. Find the standard deviation b. Add 5 to each data set value and find the standard deviation. c. Subtract 5 from each value and find the standard deviation. d. Multiply by 5 on each value and find the standard deviation. e. Divide by 5 on each value and find the standard deviation. f. Generalize the results in parts a-e.
On June 30, $185,000 of 5-year, 10% Orbit bonds are issued at $171,383 to yield a...
On June 30, $185,000 of 5-year, 10% Orbit bonds are issued at $171,383 to yield a market interest rate of 12%. Interest is payable semi-annually each June 30 and December 31. (a) Record the purchase of these bonds on June 30 and the receipt of the first interest payment on December 31 on the books of the investor assuming the bonds are to be held to maturity. (Credit account titles are automatically indented when the amount is entered. Do not...
On 1 April 2019, Exotica Ltd borrowed $56,870 from the bank at 10% per annum interest....
On 1 April 2019, Exotica Ltd borrowed $56,870 from the bank at 10% per annum interest. This loan was a secured loan and is was for one year. This loan is repayable in amounts of $5,000 at the end of each month. Required 1. In an excel spreadsheet prepare a journal entry to record the initial mortgage (1 mark). 2. Within the Excel spreadsheet prepare a mortgage schedule for this loan. Round your calculations to two decimal places and the...
Read the case and answer the following questions.                                  30 Mark
Read the case and answer the following questions.                                  30 Marks                                Richard Dana Associates (RDA) was brought in by the owners of a family-owned business with complex relationship issues at a time preceding an anticipated leadership transition. Following individual and group coaching sessions, RDA was able to help the leadership separate personal issues, and codify practices through formal policies to allow the leadership group to focus on business issues without personal complications. At the end of RDA's engagement, the client was...
   Use the following information to answer questions 7.     On January 1, 2020, Beck Co....
   Use the following information to answer questions 7.     On January 1, 2020, Beck Co. issued (sold) ten-year bonds with a face amount of $3,000,000 and a stated      interest rate of 10%. Interest is payable semi-annually on January1 and July 1st of each year.      The bonds were priced to yield 8% (market interest rate).             Present value factors are as follows:                                                                                                                     At 4%                 At 8%          At 10% Present value of $1 for 10 periods 0.6756...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT