All categories

3 years ago

PROJECT: USING ADVANCED FORMULAS

Business

2 answers:

sweet [91]3 years ago

8 0

Answer:

here you go edmentum

Explanation:

marin [14]3 years ago

5 0

Answer:

Total hours worked for two weeks by all employees = 686 hours

Total Gross pay of all employees = $8,575.00

Total State income tax of all employees = $488.78

Total Federal income tax of all employees = $1,286.25

Total Social Security of all employees = $300.13

Total Net Pay of all employees = $6,499.85

Explanation:

Note: See the attached excel file for the calculation of the company's payroll or amount paid to each employee and the total amount paid to all employees on a spreadsheet as required by the question.

In the attached excel file, the following formula are used:

Gross pay for each employee = Pay rate of $12.50 per hour * Total hours worked for two weeks by each employee

State income tax for each employee = 5.7% * Gross pay for each employee

Federal income tax for each employee = 15% * Gross pay for each employee

Social Security for each employee = 3.5% * Gross pay for each employee

Download xlsx

Read more about Price indexes

<em>brainly.com/question/2254295</em>

7 0

2 years ago

In one or more complete sentences, explain the details and requirements to obtain a driver license.

ycow [4]

To obtain a drivers license you must have a permit first.
-You must drive daily and "do not" get stopped by the cops while you have your permit or you wont get your license.
-While having your permit you must have a passenger 18 or older by your side at all times while driving with a permit.
-You must read the book of license. (DMV Drivers License Booklet)
-If you want more information about how to get your license, i suggest you read the DMV booklet.
Hope this answer helped!:)

6 0

3 years ago

If you were using a simple exponential smoothing forecast model (alpha value equal to 0.30) that generated a forecast of 25.10 u

AveGali [126]

The simple exponential smoothing is a method suitable for predicting data with no style or seasonal pattern. While in Moving Averages the past observations are weighted similarly, Exponential Smoothing allocates exponentially lessening weights as the observation get older.

<span>Forecast for upcoming week = 25.10 + 0.3 (31 – 25.10) = 26.87</span>

7 0

3 years ago

First National Bank Assets Liabilities and Net Worth US Treasury Bonds $450,000 Net Worth $500,000 Reserves (Cash) $175,000 Chec

Firdavs [7]

Answer:

The Required Reserve Ratio is 25% for all banks. Assuming that all the customers that have outstanding loans have used all of those additional funds to invest in new machinery for their businesses (therefore, the amount of Checkable Deposits is the true liability the bank has to its customers), the whole system (these three banks) is capable of creating $___3,400,000____ in new loans.

Explanation:

a) Data and Calculations:

Required Reserve Ratio (RRR) = 25%

Checkable Deposits:

First National Bank $250,000

Second National Bank 100,000

Third National Bank 500,000

Total of Checkable Deposits = $850,000

Money Supply = Total Checkable Deposits/Required Reserve Ratio

= $850,000/25%

= $3,400,000

b) The computation of the total Money Supply is based on the stated assumption that "all the customers that have outstanding loans have used all of those additional funds to invest in new machinery for their businesses (therefore, the amount of Checkable Deposits is the true liability the bank has to its customers)."

4 0

3 years ago

Based on market values, Gubler's Gym has an equity multiplier of 1.46 times. Shareholders require a return of 10.91 percent on t

rewona [7]

Answer:

The answer is "5.4% and 15,23,500".

Explanation:

Calculating the capital cost:

$=(1-\frac{1}{1.46})\times 10.91\% \times (1-39\%)+(\frac{1}{1.46})\times 4.84\% \\\\=(\frac{1.46-1}{1.46})\times \frac{10.91}{100} \times (\frac{100-39}{100})+(\frac{1}{1.46})\times \frac{4.84}{100} \\\\ =(\frac{0.46}{1.46})\times \frac{10.91}{100} \times (\frac{61}{100})+(\frac{1}{1.46})\times \frac{4.84}{100} \\\\=\frac{306.1346}{14600}+\frac{4.84}{146} \\\\= 0.021+0.033 \\\\ =0.054\\\\= 5.4\%$

Maximum amount to be spent

$=\frac{277,000\times 100 }{5.4} \times (1-\frac{1}{(1.054)^7})\\\\=\frac{277,000\times 100 }{5.4} \times (1-\frac{1}{1.44})\\\\=\frac{277,000\times 100 }{5.4} \times (1-0.7)\\\\=277,000 \times 100\times 0.055\\\\=\$15,23,500\\$

6 0

3 years ago