Assume that you are planning on purchasing a new car. You are considering financing the $40,000 purchase price using a car loan arranged through the car dealership. The terms of the loan are: 8 years of fixed monthly payments, and 2.4% quoted annual periodic rate of interest (this will need to be converted to a monthly rate by dividing the annual rate by 12). Assuming the loan will be completely paid off by the end of the 8 years, determine the monthly payment associated with loan, and then prepare an amortization table in a similar way as shown in the class Excel example. Include all of the months in your table, and make sure you show not only the beginning and ending balance for each month, but also the monthly payment and the breakdown between the part used to pay interest and the part used to pay down the principal. (Hint: use functions and formulas in the first row, and the beginning balance in the second row, in a way that will allow you to copy and paste to the remaining cells of your table)

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.