Business & Finance Assignment | Custom Assignment Help

The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate information about the bond assuming two different market interest rates in the Excel Simulation below. The present value factor tables are included in the first four tabs of the Excel Simulation. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

Don't use plagiarized sources. Get Your Assignment on
Business & Finance Assignment | Custom Assignment Help
Just from $13/Page
Order Now

Custom Assignment Help

  • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C6” was entered, the formula would output the result from cell C6, or 10 in this example.
  • Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation point before the cell location. From the Excel Simulation below, if in a blank cell on the Sheet1 tab “=’Future Value of $1′!C13” was entered, the formula would output the result from cell C13 in the Future Value of $1 tab, or 1.10462 in this example.
  • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), – (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell “=C6+C8” was entered, the formula would add the values from those cells and output the result, or 12 in this example. If using the other math symbols the result would output an appropriate answer for its function.
  • IF function: Allows you to test a condition and return a specific value is the result is true and different value if the result is false. The syntax of the IF function is “=IF(test_condition,value_if_true,value_if_false)” and specific considerations need to be made when using this function. The test_condition argument is an evaluation of the status of a cell, such as if the value of a cell is greater than, less than, or equal to another number or cell. The value_if_true and value_if_false arguments will return any specific result for each option, such as another cell reference, a value, or text. Throughout the entire equation, if text is being used in the test_condition, value_if_true, or value_if_false arguments then the text itself should be entered in quotations so that Excel will recognize the text as a “string of text” instead of another function. From the Excel Simulation below, if in a blank cell “=IF(C6>2,”Long-Term Bond”,”Short-Term Bond”) was entered, the formula would output the result of the value_if_true since the test_condition would be result as true, or in this case the text “Long-Term Bond”. Excel processes the IF function by separating it out into separate parts. First the test_condition – Excel thinks, find cell C6 and determine if the value is greater than 2. Once Excel determines if the result of that test_condition is TRUE or FALSE, it will return the value_if_true or value_if_false.

Custom Assignment Help

  • VLOOKUP Function: Allows you find a value inside of a sorted data table by referencing the column and row labels. The syntax of the VLOOKUP function is “=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)” and results in a value found from a data table. The lookup_value argument is the value to be found in the first column of the table. The table_array is the cell reference for the data table, usually shown as a range. The col_index_num argument is the column number in the data table (table_array) where the matching value should be found. The range_lookup argument is a logical value of TRUE or FALSE, where TRUE represents the value found in the first column should be a closest match, and FALSE represents the value found in the first column should be an exact match. From the Excel Simulation below, if in a blank cell “=VLOOKUP(C6,’Future Value of $1′!B3:T27,2,FALSE)” was entered, the formula would output the result of 1.10462 in this example. Excel processes the VLOOKUP function by using each argument to find the cross-section of the column and row reference in the data table. In the example, Excel looked at the first column of the table_array on the Future Value of $1 tab cells B3:T27 and found the lookup_value of the Sheet1 cell C6 reference, or 10 periods in this example. That position in the first column is stored in Excel to know what row the final result will be found in. Remember that the first column used is the first column of the table_array and not the first column of the worksheet tab. Then the col_index_num is used by Excel to determine what column of the table_array the final result is included, or in this case the second column. Excel then finds the cross-section of those two values using the row and column references and outputs the final result from the data table.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Good work
Customer 463097, June 24th, 2022
Great work.
Customer 462927, May 24th, 2022
Healthcare & Medical
Excellent work!
Customer 463337, November 18th, 2022
Customer 452441, April 6th, 2022
Health Care
Thank you very much!
Customer 454001, February 8th, 2020
Customer 462823, April 7th, 2022
thank you so much
Customer 453933, January 25th, 2020
Good work.
Customer 456821, June 20th, 2022
Computer science
Avoidable revisions. Always check for errors.
Customer 462387, April 17th, 2022
English 101
Customer 460641, April 13th, 2022
Business and administrative studies
Customer 460073, July 2nd, 2022
good job
Customer 456821, February 28th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat