The Chestnut Street Company plans to issue $825,000, 10-year bonds that pay 7 percent 2 semiannually on March 31st and September 30th. 3 4 Information relating to this bond is found below: Face Value: $ 825,000 Number of Years: 10 Stated Interest Rate: 7% Number of Payments per Year: 9 10 Required: 11 Calculate or provide the information requested using a formula or cell reference unless 12 you are instructed to use a specific function: 13 14 1) Assume the Market Interest Rate is: 8% a. How many total payments or periods will this bond pay interest? 20 16 17 18 b. When calculating the bond selling price, show the factor from the appropriate future or present value table (found in worksheets included in this workbook) that would be used to calculate the bond interest payments. 13.59033 23c Donant question bh but now use the VI OKUD functinn 1 Present Value of Annuity of $1 Bond Pricing Repeat question b. but now use the VLOOKUP function. For the Lookup_value argument, your function should reference the result you calculated in question a. Your function should look for an exact match to the value used in the Lookup_value argument. d. Calculate the amount of interest that will be paid on March 31st. 28,875 e. Calculate the value of the interest payments that would be used when determining the bond selling price. Calculate the selling price of this bond: Using the IF function, show the word "Premium" or "Discount" based on the selling price you calculated in letter f. 2) Assume the Market Interest Rate is: 6% When calculating the bond selling price, show the factor from the appropriate future or present value table (found in worksheets included in this workbook) that would be used to calculate the bond interest payments. b. Repeat question a. but now use the VLOOKUP function. Your function should reference the result you calculated in question D E F АДА 38 2) G H B C Assume the Market Interest Rate is: 6% 39 40 a. When calculating the bond selling price, show the factor from the appropriate future or present value table (found in worksheets included in this workbook) that would be used to calculate the bond interest payments. 43 44 45 b. 46 Repeat question a. but now use the VLOOKUP function. Your function should reference the result you calculated in question Number 1 letter a.) Your function should look for an exact match to the value used in the Lookup_Value argument. 47 48 49 50 c. Calculate the amount of interest that will be paid on March 31st. 52 d. Calculate the value of the interest payments that would be used when determining the bond selling price. 55 e. Calculate the selling price of this bond: 56 57 f. Using the IF function, show the word "Premium" or "Discount" based on the selling price you calculated in letter e. 58 Dresent Value of Annuity of ¢1 Bond Pricing

Me with this asap. i will give 100 points and brainliest. part one of three (total of 100 points) how do gross national product (gnp) and gross domestic product (gdp) differ? while gnp includes investments as well as production of goods and services, gdp only includes production of goods and services. while gnp includes production by all people and businesses of a country, gdp only includes production within a country’s borders. while gnp includes production of all goods and services, gdp only includes production of final goods and services. while gnp includes imports and exports of goods and services, gdp only includes the net exports of goods and services. read the scenario. a united states company produces widgets in brazil. which is true about the calculation of widget production? the dollar value of the widgets would not be included in either a gnp or a gdp calculation. the dollar value of the widgets would be included in a gnp calculation. the dollar value of the widgets would be included in both a gnp and a gdp calculation. the dollar value of the widgets would be included in a gdp calculation. read the passage. this is the most widely used measure of inflation and is sometimes viewed as an indicator of the effectiveness of government economic policy. it provides information about price changes in the nation's economy to government, business, labor, and private citizens, and it is used by them to guide economic decisions. what is being described? consumer price index export price index producer price index import price index what is the primary tool used to measure inflation? consumer price index gross domestic product durable goods shipments gross national product how does a rise in life expectancy impact population growth? it slows population growth. it reverses population growth. it does not impact population growth. it increases population growth. why does nominal gross domestic product (gdp) sometimes seem larger than real gdp? real gdp counts only final products, whereas nominal gdp does not. real gdp counts imports, whereas nominal gdp does not. real gdp includes inflation in its calculation, whereas nominal gdp does not. real gdp uses an accurate calculation, whereas nominal gdp does not. why does nominal gross domestic product (gdp) sometimes seem larger than real gdp? real gdp counts only final products, whereas nominal gdp does not. real gdp counts imports, whereas nominal gdp does not. real gdp includes inflation in its calculation, whereas nominal gdp does not. real gdp uses an accurate calculation, whereas nominal gdp does not. what impact can government policies have on the business cycle? policies that lower interest rates may cause an economic contraction. policies that decrease spending may cause an economic expansion. policies that raise interest rates may cause an economic contraction. policies that lower taxes may cause an economic contraction. what is true regarding seasonal unemployment? it is much harder to predict than other types of unemployment. it is likely to last longer than other types of unemployment. it is not as troubling to the government as other types of unemployment. it has negative costs similar to those of other types of unemployment. read the sentence. the cost of lumber has increased 145 percent since last quarter. what is the most likely outcome in the furniture market? the market will see a rapid rise in inflation because inelastic products respond quickly to market forces. the market will see cost-push inflation because the increased cost of inputs force prices higher. the market will see demand-pull inflation because consumers need more of the product. the market will see no inflation because there has not been a change in personal income.