60.1K

Verified Solution

Link Copied!

this is just a one sum please answer all questions as soon as posible i dont have mutch time.

{A} {B} $9,000.00 $4,000.00 $5,000.00 $4,200.00 {D} 4.60% monthly 1 Cost of oil (COGS) per year 2 Infusion equipment 3 Bottling equipment 4 Other materials 5 Financing interest rate Compounumg pertous per year 6 7 Length of amortization (years) 8 Savings 9 Property and truck cost 10 Mortgage rate 11 Term of mortgage 12 Bond face value 13 Time until maturity 14 Bond rate {F} {G} {H} 3 $26,900.00 $190,000.00 3.50% {K} 8 $39,000.00 3 {M} {N} 3.20% 15 Mini-Case Jenna, Jean and Kim started a flavoured olive oil business in their final year at Cambrian College under the name Pizazi". Cost of oil (COGS) {A} Infusion equipment {B} Costs included purchasing the oil, special equipment to infuse the flavours into the oil, bottling equipment and bottles, and other materials. Bottling equipment {C} Other materials {D} Startup Loan The entrepreneurs financed the total of these costs with end-of-month payments through a loan from the bank at {E} compounded {F}, amortized over {G} years. They began selling the flavoured olive oil to local restaurants, at the local farmer's market, and online. Pizazz was the talk of the college campus and it was making a modest profit. After graduating, it was decided that they should expand their operations by renting a retail store in the city and adding 10 new flavours to their product line. They also hired an assistant to run the store, and a delivery person to handle personal orders. After two years of successfully managing Pizazz, they managed to save {H}. At this time, they must decide if they should invest their savings in property (capital expenditures) or investment bonds. Capital Expenditures Their savings can be used as a down payment to purchase a warehouse property with manufacturing capabilities, and a delivery truck. The property and truck have a combined total cost of {U}, of which {H} will be required as a down payment. The fixed interest rate on the mortgaged amount (for the property and truck) is {J} compounded {F} for a term of {K} years. B D PAYMENT NUMBER PRINCIPAL BALANCE AMOUNT PAID INTEREST PAID PRINCIPAL REPAID 2 3 4 5 6 7 8 9 10 TOTALS: Investment Bonds A{L} bond is set to mature in {M} years. The bond rate is {N} payable semi-annually. The market rate is {J}, compounded {F} (the same rate available on the mortgage). Jenna, Jean and Kim will only purchase this bond if they can afford it, and if they can get it at a discount, because they think the market rate will go down, making the bond more valuable in the future. Answer the following questions related to these debts and bond: Startup Loan a. What were their monthly payments to settle this loan? b. What was the principal balance outstanding on the loan after one year? c. What will be the size of the final payment? d. Construct a partial amortization schedule for this loan. Feel free to use the template provided in the Excel Spreadsheet to help you. Mortgage on Property and Truck e. What were their monthly payments to settle this mortgage? f. What will be the size of the final payment? g. Construct a partial amortization schedule for this loan. Feel free to use the template provided in the Excel Spreadsheet to help you. h. How long would it take to settle this loan with regular monthly payments of exactly $2000 instead of the PMT value calculated in part (a)? Investment Bonds i. Calculate the purchase price of the bond if it is purchased today ({M} years before maturity). j. Do Jenna, Jean, and Kim have enough money to buy their bond using their {H} in savings? Should they purchase the bond? Why or why not? {A} {B} $9,000.00 $4,000.00 $5,000.00 $4,200.00 {D} 4.60% monthly 1 Cost of oil (COGS) per year 2 Infusion equipment 3 Bottling equipment 4 Other materials 5 Financing interest rate Compounumg pertous per year 6 7 Length of amortization (years) 8 Savings 9 Property and truck cost 10 Mortgage rate 11 Term of mortgage 12 Bond face value 13 Time until maturity 14 Bond rate {F} {G} {H} 3 $26,900.00 $190,000.00 3.50% {K} 8 $39,000.00 3 {M} {N} 3.20% 15 Mini-Case Jenna, Jean and Kim started a flavoured olive oil business in their final year at Cambrian College under the name Pizazi". Cost of oil (COGS) {A} Infusion equipment {B} Costs included purchasing the oil, special equipment to infuse the flavours into the oil, bottling equipment and bottles, and other materials. Bottling equipment {C} Other materials {D} Startup Loan The entrepreneurs financed the total of these costs with end-of-month payments through a loan from the bank at {E} compounded {F}, amortized over {G} years. They began selling the flavoured olive oil to local restaurants, at the local farmer's market, and online. Pizazz was the talk of the college campus and it was making a modest profit. After graduating, it was decided that they should expand their operations by renting a retail store in the city and adding 10 new flavours to their product line. They also hired an assistant to run the store, and a delivery person to handle personal orders. After two years of successfully managing Pizazz, they managed to save {H}. At this time, they must decide if they should invest their savings in property (capital expenditures) or investment bonds. Capital Expenditures Their savings can be used as a down payment to purchase a warehouse property with manufacturing capabilities, and a delivery truck. The property and truck have a combined total cost of {U}, of which {H} will be required as a down payment. The fixed interest rate on the mortgaged amount (for the property and truck) is {J} compounded {F} for a term of {K} years. B D PAYMENT NUMBER PRINCIPAL BALANCE AMOUNT PAID INTEREST PAID PRINCIPAL REPAID 2 3 4 5 6 7 8 9 10 TOTALS: Investment Bonds A{L} bond is set to mature in {M} years. The bond rate is {N} payable semi-annually. The market rate is {J}, compounded {F} (the same rate available on the mortgage). Jenna, Jean and Kim will only purchase this bond if they can afford it, and if they can get it at a discount, because they think the market rate will go down, making the bond more valuable in the future. Answer the following questions related to these debts and bond: Startup Loan a. What were their monthly payments to settle this loan? b. What was the principal balance outstanding on the loan after one year? c. What will be the size of the final payment? d. Construct a partial amortization schedule for this loan. Feel free to use the template provided in the Excel Spreadsheet to help you. Mortgage on Property and Truck e. What were their monthly payments to settle this mortgage? f. What will be the size of the final payment? g. Construct a partial amortization schedule for this loan. Feel free to use the template provided in the Excel Spreadsheet to help you. h. How long would it take to settle this loan with regular monthly payments of exactly $2000 instead of the PMT value calculated in part (a)? Investment Bonds i. Calculate the purchase price of the bond if it is purchased today ({M} years before maturity). j. Do Jenna, Jean, and Kim have enough money to buy their bond using their {H} in savings? Should they purchase the bond? Why or why not

Answer & Explanation Solved by verified expert

See Answer