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 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 |
|
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 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 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 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
In: Statistics and Probability
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 that does the following:
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, 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.
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 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