# ISDS351 Julia Juice Bar Interest Rate and Amount of Loan Paper Assignment 3M.S. Excel 2013 or 2016 Julias Juice Bar Learning Objectives Goal SeekWhat-if

ISDS351 Julia Juice Bar Interest Rate and Amount of Loan Paper Assignment 3M.S. Excel 2013 or 2016 Julias Juice Bar Learning Objectives Goal SeekWhat-if sensitivity analysisCharting Use my instructional video Lesson 4ABC to complete the following: A worksheet Lastnamefirstname_A4.xls has been started for you and you need to complete it based on the following assumptions for a company called Julias Juice Bar. Julias juice bar is trying to trim down their annual maintenance expenses to 10% of the total expenses. Use Goal Seek to calculate the new amount.Julia would like to have a pie chart that would show the summary of annual percentage of expenses. Create a 3D pie chart with the given data.Julia is considering expanding her business and is planning on taking a loan for \$425,000.00 and is willing to pay no more than \$9000 per month as monthly payment. Further, she wishes to repay the loan in 4 years and is therefore willing to lower her budget if need be. You are to help her come up with the right amount to borrow. What is your recommendation. Indicate this in the space provided in the spreadsheet. Create a pdf of the entire workbook and upload it in the link provided by the due date posted. Take the following options to create the pdf version of your file. Go to backstage view, export, create pdf, options, in publish what section in the dialog box, select entire work book, then select ok and publish. Good Luck! 1
Prof. M. Krishnamurthi
ISDS 351.
Assignment 3 M.S. Excel 2013 or 2016
Julias Juice Bar
Learning Objectives
1. Goal Seek
2. What-if sensitivity analysis
3. Charting
Use my instructional video Lesson 4ABC to complete the following:
A worksheet Lastnamefirstname_A4.xls has been started for you and you need to
complete it based on the following assumptions for a company called Julias Juice
Bar.
1. Julias juice bar is trying to trim down their annual maintenance expenses
to 10% of the total expenses. Use Goal Seek to calculate the new amount.
2. Julia would like to have a pie chart that would show the summary of annual
percentage of expenses. Create a 3D pie chart with the given data.
3. Julia is considering expanding her business and is planning on taking a loan
for \$425,000.00 and is willing to pay no more than \$9000 per month as
monthly payment.
4. Further, she wishes to repay the loan in 4 years and is therefore willing to
lower her budget if need be. You are to help her come up with the right
amount to borrow. What is your recommendation. Indicate this in the
Create a pdf of the entire workbook and upload it in the link provided by the
due date posted.
Go to backstage view, export, create pdf, options, in publish what section in the
dialog box, select entire work book, then select ok and publish.
Good Luck!
Julia’s Juice Bar
Projected Decrease in Expenses
Annual Total
Employee Salaries
Equipment
Produce
Marketing
Maintenance
Totals
\$
\$
\$
\$
\$
2,678,512
2,904,123
1,345,689
3,456,123
3,412,902
Goal: Decrease Maintenance to 10%
Goal Amount
Percent of
Total
Costa Mesa Store Loan Options
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)
\$425,000
4.00
4%
Option #1 Reduce Loan Amount
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)
Option #2 Increase Number of Years
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)

attachment

Don't use plagiarized sources. Get Your Custom Essay on
ISDS351 Julia Juice Bar Interest Rate and Amount of Loan Paper Assignment 3M.S. Excel 2013 or 2016 Julias Juice Bar Learning Objectives Goal SeekWhat-if
Just from \$13/Page
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.