Questions
Project the Balance Sheet for Wal Mart for the next 5 years through year 2022. Provide...

Project the Balance Sheet for Wal Mart for the next 5 years through year 2022. Provide reasoning for your forecasts and explanation. Growth rate for 2018 is 10%, 2019 is 11%, 2020 is 5.5%, 2021 is 5% and 2022 is 4%.

Actuals
Year 2015 2016 2017
Balance Sheet
Assets:
Cash and cash equivalents 9,135 8,705 6,867
- common size 4.5% 4.4% 3.5%
- rate of change -4.7% -21.1%
Accounts and notes
receivable - net 6,778 5,624 5,835
- common size 3.3% 2.8% 2.9%
- rate of change -17.0% 3.8%
Inventories 45,141 44,469 43,046
- common size 22.2% 22.3% 21.7%
- rate of change -1.5% -3.2%
Prepaid expenses and other
current assets 2,224 1,441 1,941
- common size 1.1% 0.7% 1.0%
- rate of change -35.2% 34.7%
Current assets 63,278 60,239 57,689
- common size 31.1% 30.2% 29.0%
- rate of change -4.8% -4.2%
Property and Equipment 177,395 176,958 179,492
- common size 87.2% 88.7% 90.3%
- rate of change -0.2% 1.4%
Accumulated depreciation -63,115 -66,787 -71,782
- common size -31.0% -33.5% -36.1%
- rate of change 5.8% 7.5%
Property under capital and leasing
financing obligations, net 2,375 6,345 6,468
- common size 1.2% 3.2% 3.3%
- rate of change 167.2% 1.9%
Goodwill 18,102 16,695 17,037
- common size 8.9% 8.4% 8.6%
- rate of change -7.8% 2.0%
Other assets 5,455 6,131 9,921
- common size 2.7% 3.1% 5.0%
- rate of change 12.4% 61.8%
Total Assets 203,490 199,581 198,825
- common size 100.0% 100.0% 100.0%
- rate of change -1.9% -0.4%
Liabilities
Short-term borrowings 1,592 2,708 1,099
- common size 0.8% 1.4% 0.6%
- rate of change 70.1% -59.4%
Accounts Payable 38,410 38,487 41,433
- common size 18.9% 19.3% 20.8%
- rate of change 0.2% 7.7%
Accrued liabilities 19,152 19,607 20,654
- common size 9.4% 9.8% 10.4%
- rate of change 2.4% 5.3%
Accrued Income Taxes 1,021 521 921
- common size 0.5% 0.3% 0.5%
- rate of change -49.0% 76.8%
Long-term debt - due within
one year 4,791 2,745 2,256
- common size 2.4% 1.4% 1.1%
- rate of change -42.7% -17.8%
Capital lease and financial
obligations due within one year 287 551 565
- common size 0.1% 0.3% 0.3%
- rate of change 92.0% 2.5%
Current liabilities 65,253 64,619 66,928
- common size 32.1% 32.4% 33.7%
- rate of change -1.0% 3.6%
Long-term debt 40,889 38,214 36,015
- common size 20.1% 19.1% 18.1%
- rate of change -6.5% -5.8%
Long-term capital lease and
financing obligations 2,606 5,816 6,003
- common size 1.3% 2.9% 3.0%
- rate of change 123.2% 3.2%
Deferred income taxes and other 8,805 7,321 9,344
- common size 4.3% 3.7% 4.7%
- rate of change -16.9% 27.6%
Total liabilites 117,553 115,970 118,290
- common size 57.8% 58.1% 59.5%
- rate of change -1.3% 2.0%
Shareholder's Equity
Common stock 323 317 305
- common size 0.2% 0.2% 0.2%
- rate of change -1.9% -3.8%
Capital in excess of par value 2,462 1,805 2,371
- common size 1.2% 0.9% 1.2%
- rate of change -26.7% 31.4%
Retained Earnings 85,777 90,021 89,354
- common size 42.2% 45.1% 44.9%
- rate of change 4.9% -0.7%
Accum. other comprehensive
income (loss) -7,168 -11,597 -14,232
- common size -3.5% -5.8% -7.2%
- rate of change 61.8% 22.7%
Total Common and Preferred
Shareholders' Equity 81,394 80,546 77,798
- common size 40.0% 40.4% 39.1%
- rate of change -1.0% -3.4%
Noncontrolling interests 4,543 3,065 2,737
- common size 2.2% 1.5% 1.4%
- rate of change -32.5% -10.7%
Total Equity 85,937 83,611 80,535
- common size 42.2% 41.9% 40.5%
- rate of change -2.7% -3.7%
Total liabilites and equities 203,490 199,581 198,825
- common size 100.0% 100.0% 100.0%
- rate of change -1.9% -0.4%

In: Accounting

Rental Summary Calculate the Amount Due. amtDue = baseCharge + mileCharge Print the Customer summary as...

Rental Summary

  1. Calculate the Amount Due.
    amtDue = baseCharge + mileCharge

  2. Print the Customer summary as follows:

Rental Summary
Rental Code:        The rental code
Rental Period:      The number of days the vehicle was rented
Starting Odometer:  The vehicle's odometer reading at the start of the rental period
Ending Odometer:    The vehicle's odometer reading at the end of the rental period
Miles Driven:       The number of miles driven during the rental period
Amount Due:         The amount of money billed displayed with a dollar sign and
                    rounded to two digits. For example, $125.99 or $43.87                   

Final Check
Remove ALL print code from your script, except for the Rental Summary.
The following data will be used in this final check:

Rental Code:        D
Rental Period:      5
Starting Odometer:  1234
Ending Odometer:    2222

Your final output should look like this:

Rental Code: D
Rental Period: 5
Starting Odometer: 1234
Ending Odometer: 2222
Miles Driven: 988
Amount Due: $324.40

Rental Summary Feedback Link

Before you submit your final code file for grading, it might be a good idea to get some feedback as a final check. This feedback is for your benefit and this will not submit your code for grading.

If so, click the Help Me! link below.

Help Me!

import sys
'''
Section 1: Collect customer input
'''

##Collect Customer Data - Part 1

##1)   Request Rental code:
#Prompt --> "(B)udget, (D)aily, or (W)eekly rental?"
#rentalCode = ?
rentalCode = input("(B)udget, (D)aily, or (W)eekly rental?\n")
print(rentalCode)
budget_charge = 40.00
daily_charge = 60.00
weekly_charge = 190.00
#2)   Request time period the car was rented.

#Prompt --> "Number of Days Rented:"
#rentalPeriod = ?
#   OR
#Prompt --> "Number of Weeks Rented:"
#rentalPeriod = ?
if rentalCode == 'B' or rentalCode == 'D':
rentalPeriod= int(input('Number of Days Rented:\n'))
else:
rentalPeriod =int(input('Number of Weeks Rented:\n'))

daysRented = rentalPeriod
#CUSTOMER DATA CHECK 1
#ADD CODE HERE TO PRINT:
#rentalCode
#rentalPeriod

#Calculation Part 1

##Set the base charge for the rental type as the variable baseCharge.
#The base charge is the rental period * the appropriate rate:


#Collect Customer Data - Part 2

#4)Collect Mileage information:
#a)   Prompt the user to input the starting odometer reading and store it as the variable odoStart

#Prompt -->"Starting Odometer Reading:\n"
# odoStart = ?


#b)   Prompt the user to input the ending odometer reading and store it as the variable odoEnd

#Prompt -->"Ending Odometer Reading:"
# odoEnd = ?

#c) Calculate total miles

#Print odoStart, odoEnd and totalMiles


# Calculate Charges 2

##   Calculate the mileage charge and store it as
# the variable mileCharge:

#a)   Code 'B' (budget) mileage charge: $0.25 for each mile driven

#b)   Code 'D' (daily) mileage charge: no charge if the average
# number of miles driven per day is 100 miles or less;
# i)   Calculate the averageDayMiles (totalMiles/rentalPeriod)

# ii)   If averageDayMiles is above the 100 mile per day
# limit:
# (1)   calculate extraMiles (averageDayMiles - 100)
# (2)   mileCharge is the charge for extraMiles,
# $0.25 for each mile


#c)   Code 'W' (weekly) mileage charge: no charge if the
# average number of miles driven per week is
# 900 miles or less;

# i)   Calculate the averageWeekMiles (totalMiles/ rentalPeriod)

# ii)   mileCharge is $100.00 per week if the average number of miles driven per week exceeds 900 miles

'''
Section 3: Display the results to the customer
'''
#1) Calculate the Amount Due as the variable amtDue
# This is the base charge + mile charge

#2. Display the results of the rental calculation:

print ("Rental Summary")
print("Rental Code: ", rentalCode)
print ("Rental Period: ", rentalPeriod)
print ("Starting Odometer: ", odoStart)
print ("Ending Odometer: ", odoEnd)
print ("Miles Driven: ", totalMiles)
print ("Amount Due: ", amtDue)

In: Computer Science

You are managing a mutual fund with the following stocks: Stock Investment Beta A $1,951 0.7...

You are managing a mutual fund with the following stocks:

Stock

Investment

Beta

A

$1,951

0.7

B

$2,625

0.3

What is the beta for this mutual fund (i.e. what is the portfolio beta)?

In: Finance

onsider the following questions: How much does milk cost on the East Coast of the United...

onsider the following questions: How much does milk cost on the East Coast of the United States? How many minutes does it take to drive 30 miles at an average speed of 55 miles per hour? What is the age difference between you and your siblings? How many hours of sleep do teenagers get during the school year compared to summer vacation? Define each question as being or not being a statistical question and explain why.

In: Statistics and Probability

Use graphs to illustrate the difference between a fuel tax and CAFE standard on the marginal...

Use graphs to illustrate the difference between a fuel tax and CAFE standard on the marginal cost (to the consumer) per mile driven.

Use what you know about elasticity to discuss why a fuel tax would need to be very high in order to bring about a substantial reduction in miles driven.

Use what you know about supply and demand to discuss why fuel efficiency standards might actually result in more miles driven.

In: Economics

A random sample of Midsize Sedans’ Miles per Gallon (mpg) were recorded and the                   data is...

A random sample of Midsize Sedans’ Miles per Gallon (mpg) were recorded and the                   data is listed below. Assume the miles per gallon are normally distributed:

24.6      30.2      29.9      33.1      26.7

28.5      31.6      36.3      24.4      28.7

  1. Calculate the mean (1 pt):

  1. Calculate the standard deviation (1 pt):

  1. Construct a 90% confidence interval for population mean (4 pts):
  1. Construct a 95% confidence interval for population standard deviation (4 pts):

In: Statistics and Probability

Apply the case on facebook or Microsoft. Regarding the notion of organizational culture, structure and styles...

Apply the case on facebook or Microsoft.

Regarding the notion of organizational culture, structure and styles of management from the perspectives of Handy’s (1976) and Miles & Snow (1978). These authors provided their frameworks that are different from each other’s. What you have to do:

Take an organization with which you are familiar or imaginary organization and evaluate & relate or apply Handy’s and Miles & Snow’s typologies (scientific/logical classification/steps of organizational culture, structure and styles) that they provided in their approaches or framework.

In: Operations Management

IN JAVA: Build a class called ExamPractice from scratch. This class should include a main method...

IN JAVA: Build a class called ExamPractice from scratch. This class should include a main method that does the following:

  1. Prompt the user to enter a number of inches
  2. Read the number of inches entered from the console
  3. Convert the inches into an equivalent number of miles, yards, feet, and inches.
  4. Output the results to the console.

For example, if a user entered 100000 inches, the program would output:

100000 inches is equivalent to:
Miles: 1
Yards: 1017
Feet: 2

Inches: 4

In: Computer Science

Banko Inc. manufactures sporting goods. The following information applies to a machine purchased on January 1,...

Banko Inc. manufactures sporting goods. The following information applies to a machine purchased on January 1, 2018:

Purchase price $ 71,000
Delivery cost $ 3,000
Installation charge $ 2,000
Estimated life 5 years
Estimated units 146,000
Salvage estimate $ 3,000

During 2018, the machine produced 42,000 units and during 2019, it produced 44,000 units.

Required

Determine the amount of depreciation expense for 2018 and 2019 using each of the following methods:

2018 2019
a. Straight-line not attempted not attempted
b. Double-declining-balance not attempted not attempted
c. Units of production not attempted

[The following information applies to the questions displayed below.]

Three different companies each purchased trucks on January 1, 2018, for $72,000. Each truck was expected to last four years or 200,000 miles. Salvage value was estimated to be $7,000. All three trucks were driven 67,000 miles in 2018, 42,000 miles in 2019, 40,000 miles in 2020, and 62,000 miles in 2021. Each of the three companies earned $61,000 of cash revenue during each of the four years. Company A uses straight-line depreciation, company B uses double-declining-balance depreciation, and company C uses units-of-production depreciation.

Answer each of the following questions. Ignore the effects of income taxes.

  1. a-1. Calculate the net income for 2018? (Round "Per Unit Cost" to 3 decimal places.)

Net Income
Company A not attempted
Company B not attempted
Company C


a-2. Which company will report the highest amount of net income for 2018?

  • Company A

  • Company B

  • Company C

  • All of the choices

In: Accounting

Mahoney Moving Corporation purchased a new moving truck on January 2, 2014, for $95,000. The truck...

Mahoney Moving Corporation purchased a new moving truck on January 2, 2014, for $95,000. The truck was expected to have a useful life of 4 years and a residual value of $15,000. The company estimated that the moving truck would be driven for a total of 20,000 miles. It was driven for 5,000 miles in 2014, 6,000 miles in 2015, 4,000 miles in 2016, and 5,000 miles in 2017. The company’s fiscal year ends on December 31.

Required:

1. Complete the following depreciation schedules for each year and be sure to show all of your handwritten calculations for the solutions for your depreciation schedules.

2. Create your own Excel Depreciation Spreadsheet using the following format for your own assignment.

3. Use mathematical formulas in your Excel Spreadsheet

Straight Line Depreciation

Year Depreciation Expense Accumulated Depreciation Book Value

2014 __________________ ______________________ __________

2015 __________________ ______________________ __________

2016 __________________ ______________________ __________

2017 __________________ ______________________ __________

Double Declining Balance

Year Depreciation Expense Accumulated Depreciation Book Value

2014 __________________ ______________________ __________

2015 __________________ ______________________ __________

2016 __________________ ______________________ __________

2017 __________________ ______________________ __________

Units of Production

Year Depreciation Expense Accumulated Depreciation Book Value

2014 __________________ ______________________ __________

2015 __________________ ______________________ __________

2016 __________________ ______________________ __________

2017 __________________ ______________________ __________

What would the general journal entry be if the Mahoney Moving Corporation was using the Straight Line Depreciation Method and the moving truck was sold for $30,000 at the end of 2015?

4. What would the general journal entry be if the Mahoney Moving Corporation used the Double-Declining Balance Depreciation method and the moving truck was sold for $40,000 at the end of 2016?

5. What would the general journal entry be if the Mahoney Moving Corporation used the Production Depreciation method and the moving truck was sold for $10,000 at the end of 2017?

In: Accounting