Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a} How would a knowledge of Data Analytics benet i) an accountant {5 marks} ii) an operations manager? (5 marks} You are an accountant with
a} How would a knowledge of Data Analytics benet i) an accountant {5 marks} ii) an operations manager? (5 marks} You are an accountant with ABC Company and in the process of preparing a cash flow statement. You want to reflect the payments of the $1,000,000 bank loan in the statement. Use the NPER function to determine how many years it will take to pay off the bank loan based on the facts below: - NPEerate,pmt,py,fy,type) - The rate per year is 5.5% compounded quarterly. - The payment {pmtj is $89,000 per quarter. - The present value (py) is $1,000,000, because the bank has offered to fund all of the capital required for the project. - The future value (ft!) is assumed to be $0 because no mention is made of any residual amounts owed at the end of the loan. - The type argument is assumed to be the default 0. You do not have to do the calculations iust set up the formula, explain the entries of the formula. (8 marks}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started