Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Aultimate Communicaticons is having a problem proxlucing a report ahout the products and services they sale at their varicus branches throughiout the country. They have

image text in transcribed

Aultimate Communicaticons is having a problem proxlucing a report ahout the products and services they sale at their varicus branches throughiout the country. They have given you a task ta make compulations which cant nowide the information reauired hv the Marketing directar usins the informarion nrovided in the table helnw- 1. Einter the data using the appropriate application and save the workhoxk as AultimateCom and the whksheet as Income. Calculate the total income across all the branches. 2. Calculate the net profit per branch and overally by lessing total expeuses from the tocal iocome. 3. Create 2D Columu Chart to show the toal inconse productiservice and branch for all the three brancbes using one Chart. This should be an integrated chart which enables the director to compare the values usiag one Chatt. Use the litle "laceme Ciencrated" for the Chart, center alligned on a scparatc sheet and save it as Chart1. 4. Open another sheet under the same workbook and reaame it to COUNTING.Usiag be appropriage formula, count the number of hranches whos have generated an income abowe 100,00000 fix all the products and services they are selling. 5. The company is inwnding to take a loan of 1,500,000.00 Pola from the bank. Tbe interest rate is 16Y, to be paid over 20 years. Can yoa belp the director to know the installment they will be paying on a monthly basis fot the duration staned above using the appropriake function in excel. Lo this on a separate sheet and name it PAYMENT

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

International Auditing Standards In The United States Comparing And Understanding Standards For ISA And PCAOB

Authors: Asokan Anandarajan, Gary Kleinman

2nd Edition

1953349323, 9781953349323

More Books

Students also viewed these Accounting questions

Question

=+What is your personal mission statement?

Answered: 1 week ago