Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics

Authors: Robert A Donnelly, Robert Donnelly Jr

2nd Edition

0133852288, 9780133852288

More Books

Students also viewed these General Management questions

Question

Define personality and list the big five personality traits.

Answered: 1 week ago

Question

How easy the information is to remember

Answered: 1 week ago

Question

The personal characteristics of the sender

Answered: 1 week ago