Assignment 4
pdf
keyboard_arrow_up
School
British Columbia Institute of Technology *
*We aren’t endorsed by this school
Course
MISC
Subject
Finance
Date
Feb 20, 2024
Type
Pages
4
Uploaded by SachinBawa
Reminder:
In the following box, use the
slash (/) in place of the division sign (÷).
Now move on to the course’s very last Assessment of Learning!
Assessment of Learning: Teacher-marked
Personal finance
You are near the end of this course. This is your final Assessment of Learning, which is used
to evaluate your work based on established criteria and to assign a mark. Your teacher will
provide you with feedback and a mark. This Assessment of Learning is worth 24%
of your
final mark for the course.
Instructions
There are four tasks in this Assessment of Learning.
Task 1: Knowledge and Understanding questions
1. Determine the total amount of an investment of $1400 at 3.5% simple interest for 48
months. (4 marks)
2. Determine the total interest on a loan of $5000 if the interest rate is 6.24%, compounded
monthly for 12 years. (4 marks)
3. Use the provided TVM solver to determine the interest rate on a loan of $5400 if interest is
compounded monthly for 72 months and the final amount of the loan is $6965.35. List the
values you used for present value, future value, number of years, and number of
compounding periods per year. (3 marks)
(../ilo/20/tvm_monthly/index.html)
Monthly
Payment
Solver
Present
Value
Future
Value
Annual
Interest
(%)
Number
of
Years
Monthly
Payment
PMT
Clear
4. Use the TVM solver to determine the monthly payment of a lease of $21 568 if the interest
rate is 4.8% compounded monthly for 48 months. (3 marks)
5. Over a five-year period, the maintenance on a car included two oil changes per year ($48
each), new brakes ($452), new tires ($678), and a new set of spark plugs ($145). What is
the average yearly maintenance fee on the car for the five-year period? (4 marks)
(../ilo/20/tvm_monthly/index.html)
Task 2: Thinking questions
6. Compare the cost of borrowing $4300 for six months (180 days) in the following two
scenarios. How much will you save if you take out the bank loan as opposed to the cash
advance? (12 marks)
You take out the money as a cash advance at 19.99%, compounded daily. Your
creditor charges a cash advance fee of $5.
You take out a bank loan for the amount of the purchase at 6.75%, compounded
monthly.
7. Determine the future value of a loan of $1850 at 3.6%, compounded monthly for three
years and five years. How much money would you save if you were to pay back the loan in
three years rather than five? (6 marks)
Task 3: Communication questions
8. Define the following terms: (10 marks)
Monthly credit card statement
Bond
Mortgage
Debit card
Factory holdback
9. Explain why it’s better to start contributing to a retirement savings plan at a young age
rather than at an older age. (4 marks)
10. Describe the concepts of risk, return, and access in relation to investments. Make sure to
define each term. (8 marks)
Task 4: Application questions
11. Use the TVM solver to answer this question. Suppose a new car with a purchase price of
$25 150 can be bought or leased at an interest rate of 5.6%, compounded monthly for 48
months. The down payment on the purchase is 10% of the purchase price or $2515, while
the down payment on the lease is $1040. The residual value for the lease is $14 750.
There is a similar car on the lot that is two years old, selling for $17 500. The down
payment required on the used car is $1750. Assume the residual value of the car at the end
of the lease is $0.00. (15 marks)
Determine the monthly payment for each of the three options if the terms of each loan
are the same.
Determine the total amount of interest paid on each loan.
Determine the total amount paid for each of the three options, including principal,
interest, and down payment.
12. Suri has decided to buy a car. The car has a MSRP of $24 500. She wishes to get several
upgrades that will cost $2654. She has negotiated a $2800 discount from the MSRP.
Freight costs $800. She must pay a fuel-efficiency tax of $500 and an air conditioner tax of
$90. The dealer is charging her a non-taxable administration fee of $45. Licence fees (non-
taxable) cost $80, and gas (also non-taxable) costs $50. Calculate the total amount,
including taxes, that Suri must pay the dealership. (
Note:
Tax is 13%.) (7 marks)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
(../ilo/20/tvm_monthly/index.html)
Feedback and marking
You will receive three kinds of feedback:
Your teacher will highlight the phrases on the rubric that best describe your assignment
to show you how you have done.
Your teacher will also provide you with detailed comments about the strengths of your
assignment, the areas of the assignment that need improvement, and the steps you
should take to improve your work in the future.
The final piece of feedback that you will receive will be your mark. Each of the four
categories of knowledge and skills is weighted equally at 25 marks
, making a total of
100 marks
. The final mark on this Assessment of Learning
is determined by your
teacher based on their professional judgement of the requirements for the assignment.
Rubric
Please read the “
rubric (../assets/locker_docs/mbf3c_20_rubric.pdf)
carefully.” This rubric
will be used by your teacher to assess your work. You should refer to it too, so you’ll know
exactly what your finished assignment should include.
Submission
This is your Unit 4 assessment for feedback and a grade. This assessment is worth 24% of
your course grade.
The teacher will assess your work using the rubric. Before submitting your assessment,
review the rubric to ensure that you are meeting the success criteria to the best of your ability.
When you are ready, return to the course home page and select 'Unit 2 Assignment'
from the left side navigation bar. Go to the assignment, select your files, and submit.
Next steps
Congratulations on completing all your learning activities. An email will be sent to you
outlining key information about your final test. The final test is worth 30% of your mark.
Related Documents
Related Questions
Please correct answer and don't use hend raiting
arrow_forward
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:
Costs/Benefits
College Course
Community Course
Cost
$4,300
$1,190
Distance to course
0.20 miles (walking distance)
18 miles (driving distance)
Timing of course
Weekday
Weekend
Number of meetings
16
8
Qualitative considerations
Convenience, quality of instruction
Flexibility, brief duration
Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?
Multiple Choice
College course
Community course
Both alternatives
Neither alternative
arrow_forward
Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…
arrow_forward
Compute a final numerical answer for each of the following problems. Youshould work out your solutions on loose leaf paper in an organized manner so that when I post the solutionkey, you can determine why answers that you missed were incorrect. This will allow you to LEARN fromany mistakes so you to not repeat these on the Final Exam (which is worth 35% of your grade in this class).Unless instructed otherwise on a question, round all dollar answers to 2 decimal places, record IRR valuesas a percent rounded to 2 decimal places, round payback period or profitability index values to 1 decimalplace, and record WACC values as a percent rounded to 2 decimal places.USE THE TABLE BELOW TO ANSWER THE FOLLOWING THREE (3) QUESTIONSYear Project A Cash Flows ($s) Project B Cash Flows ($s) Project C Cash Flows ($s)0 -100,000 -700,000 -2,350,0001 25,000 180,000 2,500,0002 20,000 150,000 2,500,0003 30,000 190,000 2,500,0004 25,000 140,0005 25,000 140,0006 20,000The payback period for Project A is…
arrow_forward
please answer all the questionss.,.within 30 minutes. make sure the explanation and reasons are explained in very detailed manner. else leave it for other tutor otherwise i will give negative ratings and will also report your answer for unprofessionalism. Make sure the answer is 100% correct and IS NOT COPIED FROM ANYWHERE ELSE YOUR ANSWER WILL DOWNVOTED AND REPORTED STRAIGHTAWAY. USE YOUR OWN LANGUAGE WHILST WRITING.
ATTEMPT THE QUESTION ONLY IF YOU ARE 100% CORRECT AND SURE. ELSE LEAVE IT FOR ANOTHER TUTOR. BUT PLEASE DONT PUT WRONG ANSWER ELSE I WILL REPORT.
MAKE SURE THE ANSWER IS WELL EXPLAINED AND DETAILED.
arrow_forward
Each Section should be completed in a separate spreadsheet tab and all calculations should be performed using Excel formulas:
You graduated from college and landed a new job that will start in a couple of weeks. You need to purchase a car to commute to and from your new place of employment. You have decided to buy a car that costs $40,000, and will make a $5,000 down payment, resulting in the need to take out a $35,000 loan with a 5% annual interest rate that you will pay off in equal monthly installments over the next 5 years (60 months). Calculate and provide the following information:
a) Calculate the monthly payment on the car loan.
b) Prepare an amortization table for the car loan that provides separate columns for the following for each month of the car loan: Beginning loan balance; total payment amount, amount of monthly payment allocated to interest; amount of monthly payment allocated to the principal balance; and ending loan balance. (Your amortization table is likely…
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2%
a. What formula should be used?
b. What are you trying to find and what variable does it represent in the formula?
c. Solve the problem showing all of your work (must show all steps!!)
d. Interpet your answer using a complete sentence
You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain"
button to add pictures.
arrow_forward
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
(Not written.. please)
Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following:
Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
arrow_forward
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
(Not written.. please)
Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following:
Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
arrow_forward
You are more than half way throught this class. What
knowledge have you gained? Do you see yourself
continuing in Real Estate. If you see yourself in Real
Estate, how do you see yourself working in this field? If
you don't see yourself in Real Estate, how can you apply
what have learned in this class to your future? (No
you
one word answers. Your answer needs to be at least 2
paragraphs to receive credit for this post.)
arrow_forward
Can you please help me with question A with answer in excel sheet as I didn’t understand the previous one who answer it he didn’t explain any of question A
arrow_forward
In the following exercises and problems you will be able to:• model investment and annuity problems;• explain the difference between sequences and series;• solve exercises applying concepts of the sum of sets of terms of a sequence, and• solve problems related to annuities using sequences or seriesIn the case that the result is decimal, you will round it to two decimal places.
5. Arturo just got his first full-time job after graduating from college at age 27. He decided to invest $ 200 a month in an IRA (an annuity). The interest on the annuity is 8%, which is compounded monthly. How much will be in Arturo's account when he retires at sixty-seven?
arrow_forward
You Can Do It! PRACTICE EXERCISE 3: EVALUATION: Use a separate paper to create a projected
balance sheet worksheet with the following information:
1. You have P1250 in your checking account.
2. You have P1750 in your revolving savings account.
3. You purchased a computer last summer and it is valued at P500.
4. You received a graduation gift of a watch and it is valued at P300.
5. You purchased new furniture for your apartment at P1,000, but you still owe P400.
6. Your car is valued at P5,000, but you still owe P1,500.
7. You owe P300 on a credit card.
8. You have put P1,000 into a retirement plan, Prudential life.
9. You participate in your employer's 401k program. You have saved P5,000.
10. You need a root canal procedure at your dentist office. You owe P400.
11. You just cashed your income tax refund of P1,000
12. You purchased a flat-screen TV that is valued at P500.
13. You haveP75 in cash.
14. You have a student loan balance of P20,000.
15. You purchase a condo for $60,000 and…
arrow_forward
Hello tutor please provide answer this accounting questions ⁉️
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
GEN. MATH choose 1 Situation.
arrow_forward
Evaluate these three technologies used to obtain energy and atmosphere credits
towards LEED certification by calculating total NPV and gross NPV at R=7% and complete
the table for gross and net NPV values. If you could only recommend one to your client,
which would you recommend and why? Suggestion: Set this up in an Excel spreadsheet to
make your calculations a little easier to keep track of. If you do that, please include that
spreadsheet with your assignment.
Building Technology
Install high
efficiency packaged
rooftop units (RTUS)
Comprehensive
lighting and plug
load efficiency
Incremental
Cost
$50,000
$50,000
strategy
Enhanced insulation $50,000
and glazing package
for building
envelope
Annual
Total
SPP
Savings (Yrs) Life (Yrs)
$10,000 5
12
$5,000
10
$10,000 5
Investment
10
15
Gross NPV Net NPV
arrow_forward
Q.What factors would you consider in evaluating the effectiveness of professional labor in the third quarter of 2017?
arrow_forward
1. Identify at least 3 personal goals using the SMART guidelines. Financial goals should be specific , measurable, have a definite timeframe, relevant, and imply the action to be taken. Your goals can be short term (less than a year, up to years), mid term (2-5 years), or long term (>5 years).
2. Identify your values and beliefs associated with money, write brief paragraph that identifies your values and belief about money.
3. Research 3 online financial tools or apps that you might use. These might be for budgeting, saving, shopping, coupons etc. describe the app or tool and whether you think you would use it or not. If you are already using online tools or apps, you can explain what you like or don't like about them.
arrow_forward
Use estimation to select the best response. Do not calculate.If I pay off my credit card balance each month, the most
important cost factor is
Use the editor to format your answer
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Please correct answer and don't use hend raitingarrow_forwardYou wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process: Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose? Multiple Choice College course Community course Both alternatives Neither alternativearrow_forwardPlease review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…arrow_forward
- Compute a final numerical answer for each of the following problems. Youshould work out your solutions on loose leaf paper in an organized manner so that when I post the solutionkey, you can determine why answers that you missed were incorrect. This will allow you to LEARN fromany mistakes so you to not repeat these on the Final Exam (which is worth 35% of your grade in this class).Unless instructed otherwise on a question, round all dollar answers to 2 decimal places, record IRR valuesas a percent rounded to 2 decimal places, round payback period or profitability index values to 1 decimalplace, and record WACC values as a percent rounded to 2 decimal places.USE THE TABLE BELOW TO ANSWER THE FOLLOWING THREE (3) QUESTIONSYear Project A Cash Flows ($s) Project B Cash Flows ($s) Project C Cash Flows ($s)0 -100,000 -700,000 -2,350,0001 25,000 180,000 2,500,0002 20,000 150,000 2,500,0003 30,000 190,000 2,500,0004 25,000 140,0005 25,000 140,0006 20,000The payback period for Project A is…arrow_forwardplease answer all the questionss.,.within 30 minutes. make sure the explanation and reasons are explained in very detailed manner. else leave it for other tutor otherwise i will give negative ratings and will also report your answer for unprofessionalism. Make sure the answer is 100% correct and IS NOT COPIED FROM ANYWHERE ELSE YOUR ANSWER WILL DOWNVOTED AND REPORTED STRAIGHTAWAY. USE YOUR OWN LANGUAGE WHILST WRITING. ATTEMPT THE QUESTION ONLY IF YOU ARE 100% CORRECT AND SURE. ELSE LEAVE IT FOR ANOTHER TUTOR. BUT PLEASE DONT PUT WRONG ANSWER ELSE I WILL REPORT. MAKE SURE THE ANSWER IS WELL EXPLAINED AND DETAILED.arrow_forwardEach Section should be completed in a separate spreadsheet tab and all calculations should be performed using Excel formulas: You graduated from college and landed a new job that will start in a couple of weeks. You need to purchase a car to commute to and from your new place of employment. You have decided to buy a car that costs $40,000, and will make a $5,000 down payment, resulting in the need to take out a $35,000 loan with a 5% annual interest rate that you will pay off in equal monthly installments over the next 5 years (60 months). Calculate and provide the following information: a) Calculate the monthly payment on the car loan. b) Prepare an amortization table for the car loan that provides separate columns for the following for each month of the car loan: Beginning loan balance; total payment amount, amount of monthly payment allocated to interest; amount of monthly payment allocated to the principal balance; and ending loan balance. (Your amortization table is likely…arrow_forward
- Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardFind the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.arrow_forwardPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…arrow_forward
- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…arrow_forwardYou are more than half way throught this class. What knowledge have you gained? Do you see yourself continuing in Real Estate. If you see yourself in Real Estate, how do you see yourself working in this field? If you don't see yourself in Real Estate, how can you apply what have learned in this class to your future? (No you one word answers. Your answer needs to be at least 2 paragraphs to receive credit for this post.)arrow_forwardCan you please help me with question A with answer in excel sheet as I didn’t understand the previous one who answer it he didn’t explain any of question Aarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning