Reference no: EM131226490 , Length:
Part -1:
1. A beverage distribution company, Got Beverages, Inc. took out a 4-year $700,000 loan on January 1, 2016 to help finance their upcoming capital projects. The interest rate is 4% and they will make four annual installment payments that include interest and principal to repay the note. Got Beverages, Inc. has a year-end date of December 31.
Create the amortization schedule for this note in proper format. Label your spreadsheet cell that shows your TVM calculation for the note and be sure to link all cells properly for full credit.
Data:
pv
rate
nper
pmt?
2. Show ALL journal entries that Got Beverages should make over the four year life of the loan to record all transactions related to this note payable. Be sure to date your journal entries. You do not have to provide explanations for your journal entries. Link all cells for full credit.
Module 4 Assignment 1 Excel Workbook Assignment
Part -2:
1. A larger beverage distribution company, Got More Beverages, Inc. issued a 3-year bond with a $950,000 face value on July 1, 2016 to help finance their upcoming capital projects. The coupon rate is 4% and the market rate of interest is 4.5%. Interest will be paid semi-annually on June 30 and December 31 and the face value of the bond will be paid at maturity. Got More Beverages, Inc. has a year-end date of December 31. Create the amortization schedule for this bond in proper format. Label your spreadsheet cell that shows your TVM calculation for the bond, and be sure to properly link all cells for full credit.
2. Show ALL journal entries that Got More Beverages, Inc. should make over the three year life of the bond to record all transactions related to this bond payable. Be sure to date your journal entries. You do not have to provide explanations for your journal entries. Link all cells for full credit.
|
What is the total cost of ownership
: We have determined the unit price, the in-transit carrying cost, the transportation cost, and the inventory carrying cost. if we also consider the annual ordering cost, what is the total cost of ownership?
|
|
Granting wage increases on percentage basis
: One of the objections to granting wage increases on a percentage basis is that the lowest-paid employees, who are having the most trouble making ends meet, get the smallest increase, while the highest-paid employees get the largest increase. Is this ..
|
|
Implications for a company products and profitability
: Discuss the long and short term implications for a company's products and profitability if they fix problems at the end of a production line, or stop production to deal with the problem when it is discovered.
|
|
Write about benefits and risks of carrying gun in campus
: Given the document is: Should students bring guns to colleges?- Write 4 more pages about benefits and risks of carrying gun in campus.
|
|
Create the amortization schedule
: Assignment - Excel Workbook Assignment MFE 6100 and Create the amortization schedule for this note in proper format. Label your spreadsheet cell that shows your TVM calculation for the note and be sure to link all cells properly for full credit..
|
|
Team current productivity and output
: What do you do when the animosity from past conflict with a team member, begins affecting your team's current productivity and output?
|
|
Develop a problem statement about the health service system
: Develop a problem statement about the health service system issue you select. Devise a strategy to maximize learning and afford a multi-faceted view of the health system studied. For example, you can conduct an interview with appropriate individua..
|
|
Components of the service-profit chain
: Two important components of the service-profit chain are employees and the customer. Discuss your insights into this theory and give examples of how this theory has worked or not worked in a job you have had.
|
|
Damage to goods being transported
: May a bailment exist without any verbal or written communication between the bailor and bailee? Is a common carrier liable for all loss and or damage to goods being transported?
|