1. Business
  2. Accounting
  3. unfortunately this is the third time im reposting this because...

Question: unfortunately this is the third time im reposting this because...

Question details

Unfortunately this is the third time I'm reposting this because of an insufficient answer. I need specific excel formulas for each answer. For example: PV(.085,5000,8,1000,0) or specific cell reference: =b4*b2 per each cell answer requirement.

So specific formulas for each cell that requires an answer as well as the answer. So far I've only received formulas for the "Bond price Quotation" cells.  Thank you....

Excel File Edit View Insert Format Tools Data Window Hel 书26% Tue 11:15 PM Q :E 385excel project.xlsx fou A 100% ▼ i search in Sheet A Home Layout Tables Charts SmartArt Formulas Data Review Edit FillVerdana 10AA Wrap Text ▼ General Insert Delete Format Themes Aa B20 Here is information about five bonds. In the spaces provide, for each bond, compute: 1) the amount of the stated coupon payment cash fow; 2) the amoum of the bond proceeds that would be received upon the issuance of each bond; and, 3) the resulting bond price quotation. Bond Φ Bond e Bond Bond Bond 4 Face Value s Stated Coupon Interest Rate 6 Market Yicld Rate 7 Term in Years 21,750,000 s 18,000,000 27,500,000 s 30,000,000 7.50% 7.65% 25 6.25% 6.34% 15 10,000 0.00% 5.80% 8.30% 9.20% 8.95% 20 Interest Paid NA. 10 Stated Coupon Payment 12 Bond Proceeds at Issuance 13 14 Bond Price Quotation 15 16 17 Points Earned (2 points per box) 18 19 20 21 23 24 25 26 27 CoverPro-Forma Statements Computations Car Loan Bond Valuation 珇困 Normal View Sum 0 15

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution