Present value of bonds payable; discountPinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $30,000,000 of four-year, 9% bonds, with interest payable semiannually, at a market (effective) interest rate of 10%. This information has been collected in the MicrosoftExcel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.Open spreadsheetDetermine the present value of the bonds payable. Round your answer to the nearest dollar.22,729,071xFeedbackY Check My WorkRemember, the selling price of a bond is the sum of the present values of: the face amount of the bonds due at the maturity date and the periodic interest to be paid on the bonds.The market rate of interest is used to compute the present value of both the face amount and the periodic interest.

A financial instrument with a fixed cost that helps a company to raise funds for business operations…

Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $30,000,000 of four-year, 9% bonds, with interest payable semiannually, at a market (effective) interest rate of 10%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $30,000,000 of four-year, 9% bonds, with interest payable semiannually, at a market (effective) interest rate of 10%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

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

On January 1, you win $51,750,000 in the state lottery. The $51,750,000 prize will be paid in equal installments of $5,750,000 over nine years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.Open spreadsheetDetermine the present value of your winnings. Round your answer to the nearest dollar $ fill in the blank 2
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASProblem 2:René Lara has just signed in notary #8, the contract for the purchase and sale of a house, for a value of 1'470,000.00. He showed the seller the equivalent of a 20% down payment, and the notary the deed expenses, valued at $25,000.00 and will pay the rest in equal monthly payments during the next 15 years, which include interest at 9½% nominal interest. a) Find the value of each of the monthly payments.b) Find the total amount paid.c) Find the total amount of interest paid.d) Find the effective rate. 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 answer and provide narration for each and every entry with all other work answer in text
To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both this year and last year. The amount of working capital The current ratio The acid-test ratio The average collection period (The accounts receivable at the beginning of last year totaled $250,000) The average sales period (The inventory at the beginning of last year totaled $500,000) The operating cycle The total asset turnover. (The total assets at the beginning of last year were $2,420,000) The debt-to-equity ratio The times interest earned ratio The equity multiplier (The total stockholder’s equity at the beginning of last year totaled $1,420,000) Could you please help me answer 7-9?
You are called in as a financial analyst to appraise the bonds of Olsen's Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 10 percent, which is paid semiannually. The yield to maturity on the bonds is 12 percent annual interest. There are 25 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the bonds based on semiannual analysis. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Bond price b. With 20 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) New bond price
Solve the following problems without using any software, do everything in digital format, explain the formulas, substitutions and result 1. A company has in its portfolio of assets 10 promissory notes of $ 200 each, with monthly maturities at the end of the month. The company needs liquidity and plans to sell them to a bank, which has accepted the transaction with an interest rate of 24% per year (2% per month). What amount will the company receive if the operation is carried out? In other words, what is the present value of these notes?
Solve in digital format STEP BY STEP please (Show the complete procedure please, the equations you used and the substitutions) A company requested a bank loan of $ 100,000 agreed for a two-year term, at an interest rate of 18%, with a monthly capitalization clause. What is the future amount or value of the operation?
Kavra Corporation purchased a building by signing a $150,000 long-term mortgage with monthly payments of $2,000. The mortgage carries an interest rate of 12 percent. 1. Prepare a monthly payment schedule showing the monthly payment, the interest for the month, the reduction in debt, and the unpaid balance for the first three months. (Round to the nearest dollar.)2. Prepare the journal entries to record the purchase and the first two monthly payments.
I need help with writing a formula in Excel. 6. The management has decided to go for upfront payments for 1-year instances. AWS has tie-up with eCommerceBanque Inc, wherein the bank provides loan to AWS customers for paying the upfornt payment for the reserved instance. The bank has provided loan of $2102 to the firm. The loan duration is for 1 year and the payments are required to be paid monthly (at the end). The monthly payment is $187.61 (that is the same amount charged by AWS). (i) Enter the values of number of periods, Monthly payments, Present Value and Type in cells C32, C33, C34 and C36 respectively. (ii) Write a formula in cell C37 to compute the monthly interest rate charged by the bank.(iii) Write a formula in cell C38 to convert the value calculated in C37 to annual rate.
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASMr. Romuaro Godinez comes to the financial advisor Alquimidez Serrano, and asks him to calculate the interest to be earned on a deposit for the amount of 850,000.00; when the current interest rate is 8.75%, capitalizable quarterly, and it was invested for 15 years, 4 months and 17 days. The Finance Company reinvests at simple interest when there are not complete capitalization periods.
Please provide the following journal entries for these transactions, you can draw the T- Accounts or journal entries; A) Mortgage Company funded a loan for $100,000 and the company only advance 98% of the loan through financing (Warehouse Line). Remaining 2% is gathered from Companys funds. B) The same loan was sold to investor at 102 % 15 days later, please prepare the journal entries. C) The Company has expenses at the end of the month in the amount of $20,000 but has not paid until 30 days later. Please prepare journal entries at the end of the month and 30 days payment. D) The company received funds and has a trust liability account for borrowers in the amount of $10,000. 30 days later the trust liability is being transferred to the final investors. E) Company Prepaid Insurance for 12 months and paid in January for $1,200. You are now in the March 31 st of the year.
Wally has provided the information below – and asked you to create an Income Statement and Balance Sheet for AndrewCo for the year ended December 31, 2019. Sales were $1,200,000 Gross profit margin was 50% Operating margins were 10% The Bank of Toronto provided a loan on Jan 1, 2019 worth $300,000. The annual interest is 8% and is compounded annually. Interest only payments are needed – until the loan is due in 10 years, where a balloon payment for the full balance must be paid. The combined federal and provincial tax rates is 25% Wally knows that the ending cash balance in his company is 200,000. Accounts Receivables is 12% of sales Inventory is 15% of sales Accounts Payable is 5% of sales Accrued expenses payable is 5.5% of sales Capital equipment purchases were made at the start of the year. These total $50,000. These depreciate at 10% per year The owner will provide all other capital in the form of equity financing Wally has asked you to figure out his Selling General and…

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

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

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