Reference no: EM132019959
Question: Objective: The assignment will help you to understand how changes in loan terms and payments will affect the total amount you pay.
Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan.
Copy the table from Step 1, make an extra principal payment of $2,000 on the first day of year two. How does this change the total interest you will pay on this loan?
Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan.
Copy the table from Step 3, change the interest rate to 2%. How does this change the total interest that you will pay on the loan?
What is the total amount you will pay for the car (principal and interest) in each of the steps 1,2,3 and 4.
Assignment requirements:
Any calculations must be turned in via Excel
Format and presentation of information should be easy to follow and will be considered in final grade
Use class tools and concepts to support statements and assumptions.
Assignment length should be adequate to cover the topic.
|
Prepare statement of cash flows for senoro
: Issued $1 par Common Stock for 150000 cash. Prepare Statement of Cash Flows for Senoro Co. for period ending Dec 31
|
|
What is the dollar amount paid by oil and gas
: On November 15, 2013, Oil&Gas Inc. imported 500,000 barrels of oil from an oil company in Venezuela. Oil&Gas agreed to pay 50,000,000 bolivars.
|
|
Calculate how much pay for one share of stock
: Nu-Tek, Inc. recently announced that they will pay their first annual dividend next year in the amount of $.50 a share.
|
|
Briefly describe how the asset and liability sections change
: BRIEFLY describe how the asset and liability sections of Mr. Speakers' balance sheet would change if the FASB passed and implemented the exposure draft
|
|
Create an amortization table for a new car loan
: Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan.
|
|
Find a specific event and its details
: Numerous corporate scandals occurred in the decade leading up to the financial crisis that began in 2007 and lasted into 2009.
|
|
Determine the total overhead cost applied to each jobs
: The manager also estimated the following manufacturing overhead costs for year 2015. Determine the total overhead cost applied to each jobs
|
|
What is the project discounted payback
: NPV Project L costs $65,000, its expected cash inflows are $12,000 per year for 9 years, and its WACC is 9%. What is the project's NPV?What is the project's.
|
|
What are the amounts of the yearly payments
: You borrow 10,000 at 6 % per year compounded annually. You pay it off in three equal annual payments the first occurring at the end of the fourth year.
|