Can I know how to solve this? MAT 152: Mathematics in the Modern WorldPHINMA EDUCATIONLesson #17MAKING LIVES BETTER THROUGH EDUCATIOName:Class number:ection:Schedule:Date:tructions: Solve the following problems using the formula above.AB PC Supplies obtains a P5M bank loan at 8% interest compounded semi-annually. The companyrepays the loan by paying P400, 000 every 6 months. What is the outstanding principal after the 10thpayment?"Check your answers against the Key to Corrections found at the end of this SAS.Write your score on your paper."

Loan Amount is P5million Interest rate is 8% Compounded semi annually Semi annual Interest rate…

Answered: AB PC Supplies obtains a P5M bank loan…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Course: Financial MathematicsA capitalist places a sum of $12,500 at 4% per annum and 3.5 months later, another sum of $28,500 at 4.75%. After how much time will two (2) sums placed have yielded equal interest, and how much would first sum have yielded at twice the time, and how much would first sum placed at twice the time and with a discount of 0.5% in rate have yielded? Answers: 5.6 months of time and $408.33 yields the first sum. Please procedures are needed to get answer by professor THANKS :D
5.-DO IT IN EXCEL, AND SHOW THE FORMULASThe company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment? A) $185,674.92 B) None of these amounts C) $311,662.13 D) $151,841.86
PA9. Mohammed LLC is a growing consulting firm. The following transactions take place during thecurrent year.A. On June 10, Mohammed borrows $270,000 from a bank to cover the initial cost of expansion. Terms ofthe loan is payment due in four months from June 10, with and an annual interest rate of 5%.B. On July 9, Mohammed borrows an additional $100,000 with payment due in four months from July 9,and an annual interest rate of 12%.C. Mohammed pays their accounts in full on October 10 for the June 10 loan, and on November 9 for theJuly 9 loan.Record the journal entries to recognize the initial borrowings and the two payments for Mohammed.
Answer in excel2. Suppose another graduating student also has a financial plan with regard to starting his business. He intends to borrow $25,000 from his family and friends at the end of this year to start his business. He believes his business will earn $5000 after expenses one year after it begins, another $7000 after expenses the following year, $10,000 after expenses in each of the next , two years, and $3000 in the last year before it closes. Using a 4% annual interest discount rate, determine the net present value of this investment.
5.-DO IT IN EXCEL, AND SHOW THE FORMULASThe company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment? A) $185,674.92 B) None of these amounts C) $311,662.137 D) $151,841.86 (Choose one option) D) $151,841.86
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 9.-Textiles del Desierto, S.A., negotiates an industrial equipment worth $650,000.00 (20.35) cash is sold in installments, with an advance payment of 15% and the balance in a year and a half with equal semi-annual payments, charging 16½ % interest. Find the value of each of the semiannual payments or annuities. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. please... understand the context of the exercise in Spanish, it is easy to understand.
Start your trial now! First week only $4.99!arrow_forward 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…
(Learning Objective 4: Account for warranty expense and accrued warranty payable)North Boulder USA, a tire manufacturer, guarantees its tires against defects for five years or60,000 miles, whichever comes first. Suppose North Boulder USA can expect warranty costsduring the five-year period to add up to 3% of sales. Assume that a North Boulder USA dealerin Denver, Colorado, made sales of $641,000 during 2018. North Boulder USA received cashfor 15% of the sales and took notes receivable for the remainder. Payments to satisfy customerwarranty claims totaled $18,500 during 2018.1. Record the sales, warranty expense, and warranty payments for North Boulder USA.Ignore cost of goods sold.2. Post to the Accrued Warranty Payable T-account. The beginning balance was $14,000. Atthe end of 2018, how much in accrued warranty payable does North Boulder USA owe toits customers?
A preschool ordered $2050 in books and supplies. Suppose that the bookstore offered the school a loan at 5% simple interest for 2.5 years. How much would the school need to repay the store in a single payment at the end of the term? $256.25 B. $2306.25 C. $2050 D . $265.94 2. Suppose that the bookstore in question 1 offered the school a loan at 5% interest, compounded monthly, for 2.5 years. How much interest would the school need to repay the store in a single payment on the maturity date? $256.25 B. $2306.25 C. $2050 D. $265.94 I need help and the work for both questions. I am confused
Question 1 You borrow $50,000 for 5 years. This is an amortized load, meaning that payments are the same each month, and the loan is fully paid off with final payment. The quoted interest rate (or APR) is 12% per year. What is the beginning balance, Payment, Interest, Principal and Ending Balance in months 10 and 25? Enter all the necessary information in an Excel spreadsheet as the example in class, by entering the right formulas in each column. Also copy and paste the final table from Excel in a word document and attach it with your answer.
UPVOTE WILL BE GIVEN! WRITE THE SOLUTIONS LEGIBLY. YOU MAY USE EXCEL. The amount of interest earned in 11 years on Php 1,000,000 deposited in an account paying 8% interest, compounded monthly is Php 1,403,869.28. a. True b. False
5. A recent government study reported that a college degree is worth an extra P150,000 per year income compare to high school graduate. If the interest is 6% per year and you work for 40 years, what is the future compound amount of this extra income? Final Answer = PHP Blank 1]

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

AB PC Supplies obtains a P5M bank loan at 8% interest compounded semi-annually. The company repays the loan by paying P400, 000 every 6 months. What is the outstanding principal after the 10th payment?