Please answer using an Excel app. Show all calculations and formulas used. Also, use an easy to follow template.

QUESTION 1)

ILLUSTRATION 4:MARRIEDNON-RESIDENT ALIEN DECEDENT (NRA)
Mrs. Kay Yakoto, a non-esident alient, died leaving the following properties and estate deductions:
	Separate Properties	Conjugal Properties
Located in the Philippines:	Mr. Yakoto	Mrs. Yakoto
Tangible Personal Properties	1,400,000	1,100,000	2,500,000
Intangible Personal Properties	300,000	600,000	200,000
Real Properties	1,300,000	1,800,000	5,800,000
Total Philippine Properties	3,000,000	3,500,000	8,500,000
Located Abroad:
Personal properties	2,000,000	1,000,000	2,000,000
Real properties	1,000,000	2,500,000	2,500,000
Total foreign properties	3,000,000	3,500,000	4,500,000
World properties	6,000,000	7,000,000	13,000,000
A breakdown of the items of LIT is prepared as follows:
	PHILIPPINES	ABROAD
	Separate	Common	Separate	Common
Obligations	1,000,000	1,400,000	1,000,000	1,600,000
Losses	200,000	400,000	200,000	-
Transfer for Public Use	350,000		250,000

QUESTION 2)

I. EXECUTIVE SUMMARY

To begin with, the reason why companies do mergers and acquisitions is because of the

competition and growth. In a world where competition is rampant, a company must

know how to cut their cost and understand the concept of innovation. Companies opt to

acquire their competitors to grow their business and eliminate the threat. In addition to

this, they look for synergies where companies expect that the overall performance

efficiency will increase and the cost to drop as each company works together with

capabilities of the other.

For this case study, the objective is to provide an in-depth analysis of the merger and

acquisition between Microsoft and Nokia in 2013. Microsoft attempts to provide a third

alternative to iPhone and Android. Accordingly, Microsoft sees a potential from Nokia

which is a victim of aggressive competition and lost its market position to its rivals

because of lack of innovation. Later in 2011, both companies entered into a partnership

which resulted in the release of Windows phone. However, in 2013, due to increased

competition and decline in the financial condition of Nokia, Microsoft acquired Nokia's

mobile divisions for US$7.2 Billion. Furthermore, the merger and acquisition between

the two companies was anticipated to be successful, given Microsoft's power in

software and Nokia in devices.

Subsequently, both Microsoft (the acquirer) and Nokia (the target company) are

introduced in this paper, giving a historical background, analysis of both the companies,their market positions and key financials as well as the Microsoft's merger and

acquisition's activity. However, problems were identified and revealed factors such as

differences in behaviors of the two companies, challenges in leadership, existing

environment upon merger and acquisition. It also revealed that Microsoft overvalued the

expected benefits it will get from acquiring Nokia. In addition, the merger failed to

convince the developers in producing software and applications for the Microsoft

smartphone products which run entirely on Windows OS. The market was also seen to

be saturated and the fact that Microsoft failed to capitalize the patents owned by Nokia.

In conclusion, post-acquisition analysis revealed that these factors caused problems

between the merger and acquisition of Microsoft and Nokia. Thereafter, Microsoft wrote

off $7.6 Billion in 2015 and admitted failure of Nokia acquisition. Furthermore, Microsoft

Mobile announced the sale of Nokia brand for a total of $350 million to HMD Global and

FIH mobile. It revealed that Microsoft has wasted at least $8 billion on its failed Nokia

acquisition

Please provide a background of the 2 mentioned companies.

QUESTION 3)

Spouses Alba had the following 2021 and 2022 data on donations:
May 03, 2021	Community property valued at P400,000 donated to Barbado, legitimate son who got
	married January 1, 2018.
July 14, 2021	Exclusive property donated to Carla, legitimate daughter who got married June 1, 2018.
	Value - P500,000.
December 30, 2021	Community Property donated to Carla. The dowry has a market value of P800,000.
REQUIRED:
1. The gift tax payable of Mrs. Alba on May 3.
2. The gift tax payable of Mr. Alba on July 14.
3. The gift tax payable of Mrs. Alba on Dec 30.