HomeworkLib
Question

You are to create an Excel spreadsheet that calculates the issue price of a bond. Your...

You are to create an Excel spreadsheet that calculates the issue price of a bond. Your spreadsheet should prompt the user for all relevant inputs, then calculate and clearly display the issue price. Email your completed spreadsheet to me. If you do this project with a colleague, please include both names on the spreadsheet.

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
Please provide Inputs in the following fields as per instructions
Bond Face Value "a" a
Coupon Rate offered by Bond "x" x
Frequency of interest payment per year n
Assumed Market Rate "r" r
No. of years left for redemption "n" N
Solution Part
Present Value
Present value of Redemption value of Bond after "n" years (1) =a/(1+(r/n))^(N*n)
Present Value of Interest Received in each year till redemption (2) =PV((r/n),(N*n),(a*x))
Issue Price of the Bond =(1)+(2)
0 0
Add a comment
Know the answer?
Add Answer to:
You are to create an Excel spreadsheet that calculates the issue price of a bond. Your...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • You are to create an Excel spreadsheet that calculates the issue price of a bond. Pick...

    You are to create an Excel spreadsheet that calculates the issue price of a bond. Pick any bond! Your spreadsheet should prompt the user for all relevant inputs, then calculate and clearly display the issue price. Email your completed spreadsheet to me. If you do this project with a colleague, please include both names on the spreadsheet.

  • 7.2 Write a Java program called to create an Excel spreadsheet Create a class called Food...

    7.2 Write a Java program called to create an Excel spreadsheet Create a class called Food to represent a Lunch food item. Fields include name, calories, carbs In a main method (of a different class), ask the user "How many things are you going to eat for lunch?". Loop through each food item and prompt the user to enter the name, calories, and grams of carbs for that food item. Create a Food object with this data, and store each...

  • In this assignment you will be working with bonds. You will compute bond issue price, then...

    In this assignment you will be working with bonds. You will compute bond issue price, then make an amortization table. You will then do a few select journal entries using your amortization table. Here is the data: •   Bond issue principal amount: 500,000 •   Semi-annual interest payments at the end of every six months •   Term = 5 years •   Stated rate = 6% •   Interest payment = ? Scenarios: 1.   Market rate = 4% 2.   Market rate = 6%...

  • Project Sections Section I: Sales Forecasting (Spreadsheet Only) Create an Excel spreadsheet for sales forecasting. The...

    Project Sections Section I: Sales Forecasting (Spreadsheet Only) Create an Excel spreadsheet for sales forecasting. The spreadsheet should clearly show the forecasting/projected total sales and other necessary elements explaining how the total sales are calculated. Build the spreadsheet based on the data below. Your facility is the multi-purpose stadium in Charlotte, NC. The stadium hosts various sport and cultural events annually. The events and the expected attendance are illustrated in the table below. You manage the concession stands in the...

  • In this assignment you will be working with bonds. You will compute bond issue price, then...

    In this assignment you will be working with bonds. You will compute bond issue price, then make an amortization table. You will then do a few select journal entries using your amortization table. Here is the data: Bond issue principal amount: 800,000 Semi-annual interest payments at the end of every six months Term = 6 years Stated rate = 6% Interest payment = ? Scenarios: Market rate = 4% Market rate = 6% Market rate = 8% Requirements: For each...

  • (Use an Excel spreadsheet) create a household budget showing 2 columns: Monthly Budget and an Annualized...

    (Use an Excel spreadsheet) create a household budget showing 2 columns: Monthly Budget and an Annualized Budget. Create a fictitious profile and be sure it has appropriate formatting utilized within excel, utilization of formulas when appropriate, does budget category/line items make sense, and were all items that tend to impact a budget for an average household accounted for. ***Please show the FORMULAS and where to put them on EXCEL and steps.*** *****your model should contain formulas in relevant places on...

  • Create a Spreadsheet for the following inputs, report, and statistics. Part 1 Enter inputs and develop...

    Create a Spreadsheet for the following inputs, report, and statistics. Part 1 Enter inputs and develop income statement report. Create an input area on your spreadsheet. Enter the following: Current Sales Volume (Units) 5,000 Variable Cost Per unit $7.60 Sales Price Per Unit $19.00 Fixed Costs $300,000 Target Net Income Level $120,000 When grading, these inputs will be changed by the instructor. Your model should automatically change appropriately. Develop a Spreadsheet model to report the following: Income Statement at Current...

  • Create an amortization schedule via excel, using the following data listed above. Skills & Knowledge: Calculate...

    Create an amortization schedule via excel, using the following data listed above. Skills & Knowledge: Calculate the selling price of bonds using Excel and create a bond amortization schedule using Excel Task: Use Excel and the data provided below to: 1. Calculate the price of the bond and 2.Create an amortization schedule Use the amortization schedule format reflected in Chapter 14 of the required textbook. st" 1 in eto tting e il' wad nam asf ond Once you save and...

  • please help me create this excel sheet. thank you. this is all that the teacher provided...

    please help me create this excel sheet. thank you. this is all that the teacher provided she would like us to answer in excel. Sheet 1: Name sheet Budget 2020. Create a 2020 Budget for yourself. It should include the following: Income, Total Income, Expenses (can include mortgage, electricity, cable or dish, college (tuition, books), insurance, car payment, food, entertainment, etc), Total Expenses, Net Income (Income minus Expenses). Formulas must be designed that calculate accurately. Formulas to include Sum, Min,...

  • Can you help me to create this program, please? Prompt the user for the user for...

    Can you help me to create this program, please? Prompt the user for the user for a number of degrees in Fahrenheit as an int. That number should be passed to a function named ffocREFO. This function will do the necessary calculation to convert the passed temperature to degrees Celsius as a double. The function MUST have a void return type and have the following prototype: void ffccREF(double& celsius, int Faren); In your main, display both the entered temperature and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT