1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Rudiy27
3 years ago
15

Calculate the loan balance for each of the six months. The loan balance is calculated as the additional cash needed for a given

month minus any cash used to retire debt for that month plus the loan balance carried from the prior month.

Business
1 answer:
alexandr402 [8]3 years ago
3 0

Answer:

The closing balance from the excel sheet is $5,000.00

Explanation:

Solution

Given that:

The loan balance required l for each month can be computed  as follows:

The loan balance = additional cash needed – cash used to retire debt + loan balance from previous month

Now

By applying the excel formula to perform this task is stated as follows:

D34 = SUM(D31-D33,C34)

The same formula is used to get the values for E34 to I34.

Kindly find an attached copy  of the updated excel sheet after applying above formula which is a part of the solution is as follows:

You might be interested in
Davis Company uses a standard cost system for its production process and applies overhead based on direct labor hours. The follo
evablogger [386]

Answer:

$1,800

Explanation:

Calculation to determine the variable overhead efficiency variance

Using this formula

VOH Efficiency Variance = Budgeted VOH based on Actual - Budgeted VOH/Standard Qty

Let plug in the formula

VOH Efficiency Variance = ((16,000 * $1.80/hr) - ((5,000 * 3.00hrs/unit * $1.80/hr))

VOH Efficiency Variance = $(28,800.00 - $27,000.00)

VOH Efficiency Variance = $1.800

Therefore Using the four-variance approach, what is the variable overhead efficiency variance will be $1,800

8 0
2 years ago
Suppose you own a stock that you believe will produce a return of 13% in a good economy and 4% in a poor economy. Given the prob
agasfer [191]

Answer:

The correct answer is letter "B": Expected return.

Explanation:

Expected return is the return an investor expects from an investment given the investment's historical return or probable rates of return under different scenarios. To determine expected returns based on historical data, an investor simply calculates an average of the investment's historical return percentages and then, uses that average as the expected return for the next investment period.

In the example, the expected return would be:

<em>Expected return </em><em>= (return in a good economy + return in a poor economy)/2</em>

<em>Expected return </em><em>= (13% + 4%)/2</em>

<em>Expected return </em><em>= </em><em>8,5%</em>

7 0
3 years ago
A 50 year old customer receives an inheritance of $1,000,000 which he places with an investment adviser to invest with the objec
AfilCa [17]

Answer: 10%

Explanation:

Given that :

Worth of investment = $1,000,000

Worth after 1 year = $1,300,000

Worth after 2 years = $1,200,000

From the above, investment recorded $300,000 increase after one year and $100,000 Depreciation at the end of the second year.

Therefore, Net increase:

$300,000 - $100,000 = $200,000 (after 2 years)

Therefore, average yearly/annual increase = $200,000 / 2 = $100,000

Therefore, the annual return on the investment is :

(Annual increase / investment worth) × 100%

(100,000 : 1,000,000) × 100%

0.1 × 100% = 10%

= 10%

8 0
2 years ago
A company reported net income of $9,660,000 for the year. There were 4.1 million shares of common stock outstanding at the begin
AURORKA [14]

THE COMPANY'S EARNING PER SHARE FOR THE YEAR WILL BE $2.30 PER SHARE.

Explanation:

FOR CALCULATING EARNING PER SHARE WE HAVE TO USED THE FOLLOWING FORMULA:

EARNING PER SHARE = \frac{NET INCOME}{AVERAGE OF COMMON STOCK}

GIVEN:

NET INCOME = $9,660,000

NO. OF OUTSTANDING SHARE AT BEGINNING OF YEAR = 4,100,000

NO. OF OUTSTANDING SHARE AT END OF YEAR = 4,300,000

AS PER GIVEN FORMULA :

AVERAGE COMMON STOCK OUT  STANDING = \frac{4,100,000+4,300,000}{2} = 4200000 SHARES

NOW WE WILL FIND EARNING PER SHARE USING ABOVE FORMULA:

                 \frac{9,660,000}{4,200,000}

EARNING PER SHARE  = $ 2.30 PER SHARE

6 0
3 years ago
In 1975, part IV was added to Title 35 as a major amendment dealing with _________ patent rights.
S_A_V [24]

International patent rights.

Part IV of US Code Title 35 established the <u>Patent Cooperation Treaty</u> which made it easier to protect your idea  via patent in every country that agreed  to the treaty.

6 0
3 years ago
Other questions:
  • A company currently pays a dividend of $3.4 per share (D0 = $3.4). It is estimated that the company's dividend will grow at a ra
    10·1 answer
  • A 60,000 square meter rectangular yard is to be enclosed on three sides by wood fencing that costs $25.00 per meter and on the f
    12·1 answer
  • A marketing professor in Ithaca, New York, maintains a museum of failed consumer products. Most new products in this museum fail
    11·1 answer
  • How does a country’s GPD help you determine if it’s economy is strong or weak
    15·1 answer
  • Based on his​ preferences, Bill is willing to trade 5 movie tickets for 1 ticket to a basketball game. If movie tickets cost ​$1
    9·1 answer
  • You own a portfolio that is 23 percent invested in Stock X, 38 percent in Stock Y, and 39 percent in Stock Z. The expected retur
    10·1 answer
  • Quality improvement teams are groups of people from various work areas who define, analyze, and solve common production problems
    9·1 answer
  • The decisions concerning an organization's goals and future plans are called a. tactical decisions. b. strategic decisions. c. o
    9·1 answer
  • During the most recent month, the following activity was recorded:_______.
    14·2 answers
  • Predictors and Effects of Participation in Peer Support: A Prospective Structural Equation Modeling Analysis
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!